Your reaction to Prodigy seems to be very common. Spread the word!
It’s unfortunate that many franchise fans let themselves be put off by the kids/family branding, animation or the fact that it starts out in a place and situation that feels more like another franchise in order to draw new audiences in.
That does mean though that it has room to grow. Prospective buyers are taking note of the numbers of new viewers even since it was pulled from Paramount+.
Most of it is no less great on average than 90s Trek. Just different.
It’s unfortunate many longtime fans weren’t willing to give it a chance to find its groove, much the same as the TOS fans resisted giving TNG a chance.
TNG’ first season and much of the second were rough, but it was a personal risk to stand up at a Star Trek Con in 1989 and say you were a TNG fan. By 1993, when DS9 was running too, everyone at cons were TNG fans too.
As a long haul fan who saw this happen then, I’ve found it sad to see Trek fandom repeating the cycle.