I like the Enterprise-E's design a lot more than some people. The damn cutaway poster hangs on my wall. The one for the Enterprise-D does not.
That said, it was absolutely ridiculous to destroy the 'D,' and the manner in which it was done, while it made for a somewhat compelling action scene, was preposterous. The show had made the 'D' a character, and it was needless to throw her away in such a manner.
I'm not calling any one person out for this because I've heard a lot of people say it, but for what reason did the 'D' not look suited for the big screen? If you don't like it, say so, but what legitimate reasons are there that the ship did not look good on the screen? The TOS design was abandoned for 'TMP' because nearly ten years had passed and great advances had been made in cinematic special effects. With TNG to 'Generations,' we're talking about a turnaround to cinema of less than a year, and the only difference in effects was the amount of time and money spent, and the change from video-based effects to film-based and CGI effects.
The design of the 'D' was remarkably detailed and the six-foot model was a quality model, built comparable to the quality of the film models of the time. The mere fact that the Excelsior model was used both on television, particularly when seen side by side with the 'D,' should demonstrate that there was a good amount of overlap in special effects quality. The four-foot model (and probably the smaller three-foot model) would not be not well suited for film, but 'Generations' proved that the six-foot 'D' model, properly refurbished and combined with CGI when necessary, was well-suited for the job. IIRC, the only reason the four-footer was used for TV was because the six-footer was so big, and the subtle details of its hull translated badly to video effcts.
I'm only left to think that the perception that the ship didn't look good on the big screen is due to remembering the video-based effects and four-footer from the show, compared to the six-footer and film effects from 'Generations.'
I understand that TPTB wanted a new ship and were pretty prickly about having a hero ship crossover, but to me it's just a flimsy excuse for more merchandising licenses.