It's a good reason to use only connies though.
The writers probably had a fleet of Starfleet's best in mind, like the E was.
Just like the destruction of the Yamato on TNG or the Odyssey on DS9 wouldn't have had as much shock factor if it had been some random Excelsiors. Did they comment on which ship was supposed to be the Miranda?
I'm pretty sure a Miranda have looked gorgeous though