You have to see it as a reboot. Consider this. If there had been no other Star Trek before this and Roddenberry was alive right now and at the age he was when he first developed Star Trek, with the difference in the level of technology we have today compared to what we had in the sixties and the difference in societal structures between now and then, would Roddenberry still make Star Trek exactly as he made it originally? Or, would he challenge the notions we live by today as he did back then? Undoubtedly Star Trek created by Roddenberry right now would be quite different from the original Star Trek. I'm sure it wouldn't be much like Discovery, but then the creators of this show aren't Roddenberry.
Roddenberry would never have done the "cool over logic" thing they are trying to do in Discovery. He never would have signed off on the Dutch angles, the flashy but illogically magical "tech", the shiny stylish uniforms with sneakers, the dark bridge, etc. Discovery relies way too much on flash and bang, and not enough on story. The story they are telling should be appropriate to the timeline of Star Trek, and that is not a function of how it looks. Roddenberry's "perfect" concept Trek was TNG. TOS was his "compromise" Trek. I am not sure he would have done DS9 at all, and he would take issue with many things in Voyager but not much. Enterprise would never have been done the way it was done with the trampling of canon. Canon IS important to Star Trek. You can't just change it or insert things into it retroactively. Creating new canon in a new show is okay, as long as Star Trek is extending it and not something entirely different like this show is.
I look at this show as a thing of its own. A separate entity aside from the older Star Trek shows. I would have liked a new Star Trek show like the older shows or a continuation of those shows, but because I can set this aside from those I am still able to enjoy it without being bothered by the continuity errors which bother you so much. Sure, I don't like the idea of the spore drive at all and especially not the way it makes the ship spin. But if I look at how the original shows all portray warp drive, it is really equally ridiculous. Imagine standing on a Star Ship which then instantly accelerates to the speed of light. There would be nothing left of you. I think deep down every Star Trek fan knows that this warp drive concept is ridiculously unfeasible, yet they've all come to accept and embrace it.
Not really. Warp drive is not really a gimmick at all, and the Star Trek method is actually being explored by NASA. How? Because the theoretical science behind it is sound: create a zone of space which is warped, and essentially the ship becomes isolated from normal space. Then, you can apply thrust to the bubble and not the ship, allowing it to travel faster than the speed of light. (See Albucuirre Warp Drive). The spore drive in Discovery is complete fantasy having ZERO basis in any sort of science. No, there are not spores permeating the galaxy, and even if there were, how could they be used to travel anywhere? THAT is ridiculous. The tardigrade and the chamber where Staments goes into a trance and sees his dead lover and all of that is just plain magic. It doesn't help to see the pixie dust swirling around him while he is in that chamber. Then there is the whirlygig ship movement. WHY? The ship does not need to spin like a drill, and how exactly does the spinning saucer section work in the process? It's all visual wow and no substance. Not Star Trek.
Really it is just a gimmick. But it is a necessary gimmick as you can't tell the stories which are told in Star Trek if the ship takes millennia to reach it's next destination. The spore drive is basically the exact same thing, a gimmick to allow for certain stories to be formed, but more powerful than the warp drive. For me the most annoying part of the spore drive is the ridiculous concept of it with the mycelial network and then the spinning of the ship and stuff. You appear to be mostly hung up on the fact that there is no mention of the spore drive in the original shows and because this show pre-dates those and the spore drive is more powerful than warp drive this creates a continuity error.
Just let it go and consider this unrelated to the other Star Trek shows and that problem disappears. No more continuity errors. Try to judge the show on its own merit only, as if no prior Star Trek ever existed. I know it'll be hard but it can be done. If you still don't like it then, fair enough, but you'll probably not like it for entirely different reasons than you do now, or you'll not like it a little bit less than you do now.
That would be nice, but this show is calling itself Star Trek and that can't be ignored. They are bringing in characters from real Star Trek and changing them into tropes that don't even remotely match the originals in behavior or background. As a fan, I can't be okay with this. I am no more likely to accept this crap as Star Trek as I would to go to a restaurant and order a steak and potatoes dinner and accept a plate of chicken and kale calling itself a steak dinner.