Honestly, the only time the size of an Enterprise (that I recall) was ever directly mentioned was in First Contact, and that simply set an upper bound of "almost 700 meters".
Everything else is *not* canon. Effects shots rarely match dialog. How many times did Word mention an object tens of thousands of kilometers away, and then have the scene immediately cut to an exterior shot showing the warbird/freighter/battlecruiser/whatever sitting right off the nose of the ship.
Interior sets rarely matched exterior scales. You'd have to double the size of the E-D to fit Ten Forward. The E-A has, what, 80 decks according to TFF? The Defiant and Bird of Prey changed from scene to scene. And all that was from people who cared deeply about consistency. They STILL produced shots that made zero sense.
Bad Robot, and associated production houses, care even less. The ship is precisely as big as the it needs to fit the frame of the current scene. Ad Astris covered all that at length. As did a thread I saw on here that made a perfectly justified claim that the Excelsior was 600+ meters long too. Just this thread shows conflicting evidence for the stated size of the NX and the one time it showed up on screen with a ship with a " known" length.
Mike Okuda is not the Pope of Star Trek, nor is Bernd Schneider. The size is what you want it to be.
