I'm an eternal optimist when it comes to trek. Discovery season 1 and 2 were hurt by behind the scenes drama. Season 3 was better, but not yet great. Picard shows glimmers of promise, but has some issues. SNW is supposed to be classic Star Trek, as they have stated their goal is to have all the shows have very different feels, so as to not promote burnout. You just have to get past the aesthetic redesign, which, while more than I would have preferred, is worlds better than JJTrek.
Frankly, I want Rod Roddenberry to find a way to take it back, and then put Ira Behr in charge of production. Rod didn't "get" Star Trek when he was growing up -- it was always just the thing that kept his dad from being home. He actually rather resented it. At some point, about the time CBS/Viacom were pushing up their sleeves to start seriously screwing up Trek, he had an encounter with a fan. In the most general terms, he asked why the guy loved Star Trek so much, and the guy told him, and Rod's ghast was solidly flabbered. He made a documentary about his delve into finding out what Trek meant to the people who love it, why it's so important. I highly recommend watching it. Some of the other things he's done around and since that project... Well, I'll just say in closing that I trust him to do it right more than anyone else. Even me (I know and get Star Trek, but I'm not in "the biz" -- I'd likely get chewed up and spat out... I'd make a good story editor, but not a showrunner).