Family oriented seems the target.
It’s pretty gritty for kids, but many school aged kids are up for that. It’s especially so given that Prodigy uses the classic situation of exploited orphans who are given hope and opportunities for something better.
It’s also taking advantage of the fact that Janeway in particular and Voyager generally has been the gateway for preteens into the franchise since its been available on streaming.
TNG Picard was a better captain, I can agree.
Not sure I can say that about movie Picard, and would definitely disagree that Picard in Picard was better than Kirk in TOS or the movies.
I’m from an older generation that saw TOS and loved it long before TNG existed. Taking the long view, I think it’s great that the shows are demonstrating that different kinds of leadership work, and some work better in central contexts than others. SNW seems to be making that point directly, but it’s also not afraid to laugh at itself and ask us to join in.
In the 90s, I became a huge TNG fan, loved its more serious tone, idolized Picard as an leader, and found TOS’ campiness hard to take. So I stopped watching TOS other than the movies that were still coming.
Another 30 years on, TNGs flaws (and Picard’s) are more evident to me. At this distance, TOS is such an artifact of its time that I can just accept and enjoy it again for what it is.
But in the 90s, there were other, vocal, OG TOS fans who never got that Star Trek feeling from TNG. They wanted more adventure, but I suspect that some also wanted more of the cheekiness and cheesiness that TOS delivered with a straight face. I felt at the time that both Voyager and Enterprise were to some extent designed to bring them back to the television side of the franchise, but in hindsight were also very much a reflection of the era in which they were made.
Its really good to hear from 90s Trek fans who are willing to give TOS and new shows like SNW and Lower Decks a genuine try and appreciate them for what they are.
Now, I hope you and OP will give TAS a try. There’s some great stuff in there!