By registry, however, the Constellation must pre-date the Excelsior to either a large or small degree. There's no obvious reason to reserve the number 1974, after all.
Hull numbers are sometimes used out of order for symbolic reasons. The
Zumwalt-class is numbered from DDG-1000 to DDG-1003, despite being produced during the (still ongoing) run of the
Arleigh Burke-class, which uses DDG-51 to DDG-149. Specifically,
USS Zumwalt was laid down between DDG-108 and DDG-109.
Similarly, the
Seawolf-class has hull numbers from SSN-21 to SSN-23, but was built between the
Los Angeles-class (finished with SSN-773) and the
Virginia-class (SSN-774 to SSN-816).
In both cases, the unusual order was to show that the new ships were revolutionary. The
Seawolf was highly successful but expensive, and the
Zumwalt is a cautionary tale in the annals of naval construction.
I could see the
Constellation-class as having been a more traditional successor the "great experiment," even if the
Excelsior-class was ultimately a triumph.
There are also post-Khitomer treaty stipulations to consider. In
TUC, there's discussion of "mothballing" or "[giving] up" Starfleet. The
Washington Naval Treaty that followed World War I led to inadequate "
treaty battleships" that were severely limited compared to the state of the art of the 1920s and 30s.
It's fairly easy to imagine the
Constellation and her sisters as having been the result of similar restrictions, with only a small number of additional early
Excelsiors, like the
Enterprise-B, finishing construction.
Taking only visible hull numbers into consideration, non-sequential numbering wouldn't even be necessary. The only
Constellations whose registries we actually see are the
Hathaway (NCC-2593) and the
Stargazer (NCC-2893).
While I'm understanding your head-canon approach, I have to say that the leap from the TOS aesthetic to the TMP one is the more logical approach, because you're going from a less-advanced design to a more-advanced design. DSC is basically showing the opposite of that.
The opposite does happen sometimes. In architecture, the
Chrysler Building looks like an intermediate aesthetic step between the International-style
Pan Am Building and the retro-futurist
Burj Dubai. But It's thirty years older, and firmly grounded in its era's art deco movement.
In terms of practical technology, we've recently seen military body armor return to widespread use after mostly (
cuirassiers, etc.) disappearing for hundreds of years.