I found myself nodding along to a lot that was said in this article. I also would trace a lot of recent issues to JJ Abrams’ take. What I said then is still (I think) true today: “They are good movies, but they aren’t good Star Trek movies.” Discovery and Picard suffered for it, but I think that the ills are being corrected. My hope is that Paramount greenlights “Legacy” as the TNG-spiritually-successor as SNW is the TOS-spiritual-successor.
Where I will disagree, though, is that Star Trek isn’t broken. Five-ish years ago, I would have said that, but after SNW, Lower Decks, and Picard season 3, I think the powers that be have a better understanding of what is needed. We were in a bit of a “dark-ages” from 2006-2020, but I think we’re back on the upswing. We may not be quite at 1990s golden age Trek, but we can get close.