I'm pissed about The Last Jedi as well! The best of that trilogy, and totally shit on. While I balked at the whole advertisement in act 2, it's exactly like you guys are saying: It was different, it challenged the narrative for the first time since Empire, and it felt like we were getting back into just plain old adventure scifi.
In the face of the glut of streaming and the TV angst you all talk about, we basically just do what Decider.com tells us to do. Or the Amazon reviews on Acorn or Britbox. What do we end up watching, then? Endless Britcoms and British detective dramas. It's all pork pies and cozy mysteries here, with a little Gordon Ramsey thrown in for spice, and my slavish devotion to Star Trek and, I guess, Nuwho.2.
The Star trek franchise, unlike all the others, really has found its footing. Strange New Worlds and Lower Decks have been almost 100% consistently perfect. Discovery's a boondoggle, but they're sheepishly bowing that out this year. And, even as a boondoggle, I sat through it all and don't really regret it.