Agreed, except it was mentioned in DSC that 2250's Starfleet consisted of 7,000 ships. The problem with that, of course, is that registry numbers are only in the 1,000's in that time. So that 7,000 figure probably represents the various shuttles and minor vessels without registry numbers.
The specific expression used is "active ships". So not shuttles, but we don't know what types of active ships would not get plain NCC numbers. We do see a crewed transport with an apparent Starfleet crew get a F number in the 1900 range, so that already doubles the available numberage. And then we see automated units with similar G numbers, so we're soon left wondering how Starfleet would only have mere 7,000 active ships when the registries amount to tens of thousands... Although the answer there may well be "Starfleet has had lots of ships that no longer are active".
Yes, the TOS Constitution class seemed to be both the primary workhorse of Starfleet and technologically equal to other rival powers' ships. Which is odd, because only 100 years before, Earth was extremely far behind other races such as the Vulcans and the Klingons.
And then suddenly wasn't, with the NX-01. It probably doesn't take much to catch up qualitatively: South American nations with no engineering or industrial capacity or tradition could easily purchase the mightiest dreadnoughts of the entire planet some 100-150 years ago, outclassing the previous rulers of the oceans in theory. And said rulers saw nothing wrong with selling those very dreadnoughts to those upstarts, because two British-built superships in foreign hands in the Pacific would not diminish the Royal Navy's global supremacy which was fundamentally quantitative. Vulcan might likewise have seen nothing much wrong with helping Earth build a ship that rivaled their lesser vessels (save for tractor beams initially), and then perhaps a dozen further ships that rivaled or surpassed their best.
In TOS, we basically see Starfleet's frontier forces pitted against those of other "nations". Possibly all these players would believe in "fleets in being", though, only ever risking their most expendable assets on the frontier and keeping all the powerful ships close to home. Although TMP sort of suggests this is not quite the case (perhaps the fleet in being is kept at a border starbase close to the Klingons instead?).
To be fair, the only ship we know for certain that is new is the Excelsior. We don't know the actual ages of the Miranda class or Oberth class ships seen. My opinion, however, is that they are newer than the Constitution class.
And combining the horrid loss rate of the
Constitutions in TOS with the perceived/intended age of the hero ship, we might deduce that the class is much older than its current ships.
2) The Daedalus class has been around since the 2160s. I’d imagine it would be considered old by the time of TOS. Especially so during the movies.
Old enough to be retired. The one thing we know for certain about the
Daedalus class is that it was withdrawn from service in 2196...
You’re forgetting all the ships with NX registries, since Excelsior is NX-2000.
Only temporarily: once she proves herself, she becomes NCC-2000 for her remaining appearances.
So NX in that era appears to mean the ship is a prototype or introductory unit, similarly to how the USAF adds the letter Y to its aircraft designations until a type is accepted into production and service. Starfleet might have perhaps fifteen ships with NX registries in a force of 7,000, then. But as said, TAS gives the further option of registries where we get a letter that seems related to the role of the ship: F suggestively for a Freighter (although Starfleet wouldn't do freight, that is, commercial hauling, and would have Transports instead), and G for what the 1970s writers would have associated with Guided, that is, remotely controlled things. There's no particular reason to think that these letters would go away with time like the NX would.
Which mean the rest are shuttles and transports.
Well, "active ships".
Unless that person misspoke and meant Federation, which would make more sense.
But the topic there is the Control AI and its desire to oppose or subvert Starfleet specifically.
Timo Saloniemi