When compared to other Enterprise classes such as the Constitution, Excelsior, and Galaxy, we’ve seen a surprisingly small number of Ambassador class ships, both in terms of unique vessels and on-screen appearances. What might account for the relative dearth of these ships?
Maybe a failed class, but inadvertently serving as a testbed with a lot of the lessons being incorporated into the Galaxy-class design lineage of ships?
Like how the CVN-65 USS Enterprise aircraft carrier paved the way for the Nimitz class.
That would make some sense. Its destruction during the battle could be why it was not developed further as well. Starfleet felt it wasn’t powerful enough.