I've always thought the new ship designs pulled from STO in season 3 looked exactly like the video game designs they were. Something about them didn't match with the production design of the shows.
I didn't mind so much that they used STO assets for background ships, since like most far background ships, they're just filler. What I had an issue with was the actual designs they chose. They were all just different 'skins' for 23rd & 24th century canon ships:
Alita: a different 'skin' for the Akira class (which they were still using, so why bother using an Alita?)
Edison: a different 'skin' for the 23rd century DSC Hoover class
Gagarin: a different 'skin' for the 23rd century DSC Shepard class
Pathfinder: a different 'skin' for the Intrepid class
Reliant: a different 'skin' for the Miranda class
Ross: a different 'skin' for the Galaxy class
Sutherland: a different 'skin' for the Nebula class
Here's my problem: if you're going to use assets from STO, then the designs chosen should evoke a logical starship design progression from on-screen evidence. For example, instead of using what's basically a different skin for an already aging ship class like the Nebula, perhaps they should instead have used an Avenger class starship, which evokes the TNG movie-era style of design while being more original, rather than basically taking a Nebula class and making cosmetic changes to it but basically keeping the overall shape intact. And some of the designs make no sense. Why do we have a ship that looks half like a Galaxy and half like a Sovereign? When would a ship like that have been built in-universe? And what purpose does it serve, since both classes have completely different design attributes?
And the damn Enterprise-F is a fugly eyesore. Was there ever an explanation why they didn't just make it the E instead of making that terrible throw away gag?
Matalas said that he wanted to give a tribute to players of STO by showing the Odyssey class Ent-F. Despite only perhaps less than 1% of the Star Trek fandom in total play this game. Apparently he didn't take into account the much larger percentage of Trek fans who would have liked to have some closure to the fate of the Enterprise-E other than some stupid joke at Worf's expense.