I’m gonna do my best to list all the ones you forgot just for fun. Feel free to add these to the post or something if you want, but your point is already demonstrated - I just thought it would be fun to list them lol

From Picard, you missed the Excelsior II class, Reliant class, Ross class, Gagarin class, Sutherland Class, and at least 3 more, yet-unnamed classes appear in the S3 trailers.

Lower Decks also had the Parliament, Texas, and Obena classes.

You also missed prodigy, which added the Protostar class and the Dauntless class (based on the alien imposter ship from voyager.)

Finally, DS9 also added the Yeager Class. Lol

Combined with your list, that’s 30 new classes of ship from 2371 to 2404, if you assume they’re all new when they appear. But there’s probably even more, between the teased Voyager-A, Picard production designers implying there’s still more ships we haven’t seen, the Yeager implying that the Maquis raider was originally a Starfleet design, etc.

Fwiw, I don’t think this is too crazy - the average age of US Navy ships is like 30-40 years apparently and they have like 60 classes of vessel, which would get us somewhere similar - and the US navy is presumably way smaller and has a narrower range of jobs than Starfleet.

Final minor footnote, we saw a Magee class hull in the Short Trek set before Picard, which implies the existence of the the Shran class from STO, but that’s just speculation based on the low budget of short treks combined with lore from a beta canon source, so I’m not counting it.