For me, even if we know where the story will end, and I fully accept that this is 100% the same Prime Universe we saw in TOS so that is where this will end, we still don't what will happen before the ending, and that's enough for me. And even if we know what will happen to the TOS characters, we don't know what will happen to the new characters, so there's still enough questions with there. And when the characters we know will live are in danger, I still find some suspense since we don't how they'll get out of danger.
As for it looking so different from TOS, I'm willing to allow the real world differences in a 1960s production vs a 2020s productions to overrule any in universe concerns I might have.
And I'm not really concerned with the details of the in universe references they might be contradicting, since most of what we got in TOS was rather vague, and prequels like this never line up exactly with the original. We've already gotten a storyline about Pike's accident, they've included T'Pring, and next season they're introducing Kroby, so that's enough to accept this as a direct prequel to TOS. The only things that I have trouble with are April being a white British guy in TAS and a black and American in SNW, and M'Benga seems too old and experienced to be the same character we saw in TOS.