The more literal you take them, the more literal you can take the episodes and I love taking what I see seriously. Though yeah the curve can't be exactly what we're seeing unless the characters never leave the core of the saucer.
My point of view is, I build my understanding of the ship and the universe based on what we see on screen, and if anything contradicts that (like a character saying the wrong number of decks) then I disregard it as a mistake. The size of '947 feet' was shown on screen once in the tiniest of text about as visible as the jokes on the Enterprise-D MSD, so it feels better to me to find a better number rather than trying to squeeze everything in to make it match.