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?
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.