I fully expect that the internet will be full of people telling us how awful Strange New Worlds is. How it's already been cancelled and how it's full of woke snowflakes who are useless. Even if it's the best TV show in history (which it probably won't be) because that gets people to read their page/blog/post/whatever.
Will it be as good as the best Trek that went before? Not all episodes certainly. However I doubt it'll have anything as bad as "Spocks Brain" or the entire first season of TNG. But there's so much Sci-fi and other great TV out there now (including old shows we can watch whenever we like) that it's difficult to stand out from the crowd. With ten episodes a season there will be less filler than the old series, but less opportunity to do something different and quiet, like "The Inner Light".
Hopefully it will capture some of the old magic, but in a contemporary way, I would like to return to a more episodic format that doesn't dial every threat up to eleven and mean the entire galaxy needs saving all the time.
I do worry that there are too many characters we know the fates of, meaning any threat to them is meaningless. We already had Spock, Pike and the Enterprise who we know what happens to. Now we have Uhura, Chapel and M'Benga. It limits the potential for drama.
Stuart
I like TNG S1 and "Spock's Brain...."

Well, don't look at me. I'm way to irrational this time around
Which is fine. That doesn't make TNG top shelf, much less Star Trek as a franchise as top tier entertainment. Expecting "Cause and Effect" from every show is unrealistic, at best. TNG is gone and will not be remade. That's for the better, I think.
For every "Cause and Effect" or even "Best of Both Worlds," there are 3 or 4 examples of dull, uninspired, tepid crap
Aquiel
Manhunt
Outrageous Okona
Man of the People
TNG was good. It had some brilliant episodes. But it was mostly mundane, average TV in a science fiction setting. I like it, but I don't consider it top shelf by any stretch. It's not even in my top 3 Star Trek series.