Look up "Certifiably Ingame" on whatever front-end of youtube you use, and check out his Playlist on starships. He goes into detail about various classes and specific named ships, and for the classes will bring up their naming conventions and uses and whatnot.
Side note: I don't understand the idea that an animated comedy show is somehow "less Canon" than a live action drama show.
Why?
LD is just as Canon as discovery. Honestly discovery, in my opinion, is entirely implausible because the runners were adamant that it be set before TOS, but the tech and shipsizes is definitely post DS9. Possibly even golden age of exploration huge.
But for some reason lower Decks is "not Canon" to some people...
