The -D was a far superior ship in almost every concievable way.
But more than that it was
their ship it was another character of a show, it was the ship the fans had watched for seven year. It was the Enterprise!
Then they destroyed it in a blaze of suck where everyone on the ship's compentence and IQ levels dropped 100 points. (10,000 for Data) Worf gets a chair (Apparently his reaction times in bridge-boardings weren't slow enough?) and thus it never occurs to him to unload all of the Enterprise's 5 or 6 phaser banks with a forward firing arc and a slavo of 10 torpedoes at that BoP. I mean, seriously, to quote both Be'tor and Picard himself the Enterprise was a Galaxy-class Federation flagship up against a 20 year old Bird of Prey. Shields or no shields it shouldn't have even been a match. The Enterprise could've made short, short, work of that BoP but instead it fires a couple phasers and one piddly torpedo.
The movie Generations itself shows and proves how much the ship could work on the big screen and, know what? Maybe her limitations would've forced the future movie makers to work more on stories and story-built action instead of SFX to make the movies engaging.
The -D was THEIR ship and the fan's ship. Did anyone care about the -E in First Contact? Did we care that it might get blown up or that it was being borgified? I sure as hell didn't. I had no attachment to it.
In INS we could've seen Calypso, the E-D's Captain's Yacht, used. and then finally in the Blase of Glory we could've destroyed the -D defending the Federation from Shinzon and building a "unity" between the Romulans and the Federation.
But the -E never worked for me. It screamed trying to just look cool for the sake of looking cool and it also looked like the chromosonally enhanced bastard demon child of the Excelsior and Constitution classes.
It's "nice enough", I suppose but it never struck me as a ship that called out "We're a peaceful race of explorers," but "Like us or we'll kick your ass." It's far to agressive looking a design.
It wasn't the Enterprise, that's for damn sure.
And what sings the most about it is that WHY the -D was destroyed. Not out of any dramatic necessity. Not for an emotional punch. Not for any reason close to that.
It was destroyed becasue a)TPTB thought it would be neat to land the saucer -and I'll concede that it would've been and the scene was well done- and b) pretty much because they 'didn't like it."
Why was the Enterprise destroyed in TSFS? Because Kirk had to sacrafice something for the sake of saving himself and his friend and it was a strong, big, emotional punch.
The -D's crash? Not so much.
The -D, all of the way. It was THE ship of TNG. The -E, never got to know her.