Outside of The Expanse, the rule of cool in the visual space adventure/opera medium is now "fit as many ships on screen as you conceivably can." This was the case with the Star Trek: Picard season finale as well. I don't recall the number offhand but there was something like 65 or so Romulan warships... just because there could be.
Don't get me wrong. Trek's done this before... sort of. Never mind Discovery, even — the 1990s fare went there three times, to my recollection. But on all three occasions, it felt earned. Both of the biggest battles in DS9's Dominion War had hundreds of ships, but they were essentially everything that every faction had at their disposal. It worked.
Enterprise kind of did this with the conclusion of its Xindi arc, too, but even then the writers abided by the relative lack of ships that could feasibly participate. Whether that was budgetary or not, it was, you know, less silly.
I genuinely like Star Trek: Picard, exceptionally spotty month episode notwithstanding. But yeah. That space battle was a bit like Star Trek's Sith Fleet.