I was 9 when the movie came out, and while it did take some getting used to the new nacelles, the sheer spectacle of the drydock, of how huge it looked up on the big screen, won me over.
The new Enterprise, as an object d'art, so to speak, is just plain ugly. I think most people would agree that it strikes them as ugly, even though it may be hard for them to explain exactly why. There are magical proportions and lines that the eye subliminally looks for, the golden mean and all that sort of stuff. The refit has it, and the 2009 Enterprise doesn't. It's like the difference between a Ferrari and an AMC Pacer.