Look, I've personally witnessed Voyager and Enterprise go from the worst things ever filmed to respected members of the franchise (and so have you), so forgive me if I take the gnashing of teeth over Discovery and Picard with a grain of salt. And I say that while acknowledging Discovery and Picard are very flawed shows. The issue is directly related to a fundamental incompatibility of arc based storytelling with a show set on a Starship that's supposed to go somewhere new every week. Your problem has to be big enough to require traveling the galaxy to solve, hence the reliance on galaxy ending threats. Or you get rid of the ship and get stuck in one place like Picard Season 2. There's a reason DS9, the only one set on a space station, is the only one that has successfully done long form arc based stories. And even DS9 fell back on a Galaxy spanning war in the end.
So, since the fundamental issue with new trek is arc bases stories, and SNW is episodic, forgive me for thinking SNW might actually be good.
By the way Prodigy and Lower Decks are both new Trek and they are both great. Lower Decks is explicitly is stand alone, and Prodigy isn't any more arc based than Voyager.