I'm not defending Star Trek so much as pointing out the flaws in your argument, that's all. The transporter is stupid and contrived. Warp drive is stupid and contrived. But it's science-fiction so we allow a certain suspension of disbelief.
You're really choosing to suddenly dismiss the Universal Translator™, something that's been a staple of the franchise for decades? Technology is supposed to make things easier for us, not more difficult.
I had no interest in computers growing up because I'm generally right-brained. As much as I wanted to be able to write code to make pretty pictures, I didn't have it in me. And along came Apple to provide an interface that even I could handle. And I'm guessing Ben Franklin could, too. Given how 32nd century technology was explained, I expect the crew of Discovery managed to tackle the learning curve just fine. (Except for poor Linus beaming here and there unexpectedly.)
You have a problem with dilithium still being a source of energy 800 years later? Are you as upset with fire?
Star Trek isn't perfect by any stretch but it certainly seems like there's an element of the fandom that actively seeks to find reasons to hate the franchise. Not just nitpick but hate. As a long-time Trekkie, I enjoy nitpicking as much as the next fan but not to tear the show down. It's much more creatively challenging to come up with a viable explanation. Then again, as I said, I'm right-brained.