Yeah, this is the key to enjoying the franchise, I think - accepting that the shows are all essentially standalone. The connections between any two given Star Trek series are extremely tenuous, sometimes nonexistent.This has been a very revealing discussion thread. I would have assumed that the vast majority of commentators on this website would have watched most of the Star Trek series, but there appear to be many here who have barely touched entire series. I definitely fall into the latter category- I have watched many but not nearly all of TNG, a smattering of Voyager, a handful of DS9, one episode of Discovery, and four or so SNW. It occurred to me a few years ago (although I should have realized it before) that I'm not really a Star Trek fan, I am a TOS (+TMP) fan. Not a particularly profound realization, but I think it has helped make me a little more tolerant of others' narrow enthusiasms; I'm sure there are many Discovery fans out there who don't, and don't need to, give a damn about TOS, etc
I'm a TOS and Voyager fan with mixed feelings about everything else. Sometimes mostly-positive mixed feelings, sometimes mostly-negative.