Has there ever been a decent explanation, both in terms of show production as well as in-universe why the Star Trek universe is flooded with Miranda-class starships in the time of TNG/DS9/Voy but seldom (if ever) populated with Constitution-refit-class ships?
The Constitution Class Enterprise
(i.e. NCC-1701-A) had the trademark of being "Kirk's ship", thus it's appearance in TNG at a time when we still had movies with the original Crew would have confused general audiences.
In-universe we might consider looking at the analogy of Nelson's Navy in the early 19th Century. The Royal Navy still had ships of the line like HMS Victory (or the fictional HMS Defiant depicted as a painting in "In a Mirror, Darkly") but the young US Navy felt that the faster and more maneuverable frigates like the USS Constitution
would be more efficient and usable, and this turned out to be a good decision.
In a Trek context the Miranda Class could have equally turned out to be design that allowed for more flexibility and use than the Constitution Class that may have started to look like a dinosaur.
Alternately, we do not know if they could already do baryon sweeps ("Starship Mine") in the 23rd Century, something the Constitution Class might have required more frequently than starships of the Miranda Class.
Baryon sweep technology may have arrived too late to "save" Constitution and Soyuz Class starships from the junkyard.