I like the E but I understand the criticisms and I might even be inclined to say TPTB should have just kept the D because of its familiarity for fans and iconic value for general audiences. One of the problems with the E was the structure of the TNG films themselves. We never really got to see the TNG crew on a prolonged adventure where they needed the E and it faithfully came through to save the day. We only got to see it in three films, whereas all other signature vessels (DS9 included) got enormously more screen time and grew on people through familiarity. The best way to counter this would have been to plan out a story that spanned across two or three films following First Contact (like TWOK through TVH) with the E and Our Heroes more "out there" on their own, relying on the ship for success and survival. As it was, the E was more of a glorified prop and there was nothing in the stories that made it special on its own terms. I don't agree that it's ugly, but we just never get to know her. No one ever brags on her or says how nice it is or how much they love her. It's just there as the TNG Movie Ship.