As someone who has only seen TNG and part of TOS, here’s what I’ve heard about new trek shows. Take this all with a grain of salt because I haven’t actually watched any of these:

• Discovery: Has some prestige TV characteristics. Chuds get angry about it because there’s a lot of LGBT and POC representation, and the characters talk about their feelings a lot. Gets better after the first 1-2 seasons (like many of the TNG-era shows). I bet this one is better than thinks it is.
• Picard: People generally don’t like this one. This show’s production apparently got all messed up from COVID lockdown. Patrick Stewart had perhaps too much creative input into Picard’s character. Sometimes the show gets dark and edgy. Some people really like the nostalgia fanservice in season three. Ah well, I’m still looking forward to watching the series because Q (my beloved) is in season 2, and I’ve heard he’s good in it. And I think I heard that a popular lesbian ship from Voyager becomes canon.
• Strange New Worlds: Lots of people like this one. Apparently it stays truest to the vibe of classic trek. People like it for its optimism and sexy, sexy actors. It’s the newest, so there’s not too much to say about it yet.
• Lower Decks: I think I’m looking forward to this one the most. Apparently it’s very, very good. Comedy series with lots of heart. Incorporates old trek lore in fun ways, and gets do so without all the limitations of live action. Gets better after the first 1-2 seasons (this seems to be a running theme with trek in general).