I haven't bothered to watch Discovery much, but if they did, it wouldn't be a big shocker considering they used a fucking shutterstock image for the image of the android in the "apocalypse" flashbacks.
My main gripe about Riker coming to save the day was that he seemed too happy and upbeat like he was chuggin a bottle of booze and the bridge crew was between rounds of beer pong when he was threatening Commodore "Flat note and forgettable" lady. A more serious and intimidating attitude was needed. It was too campy of a stare down.
On the subject of 7 being a lesbian, I honestly don't think she is one. She wanted that Chakotay D by the end of Voyager, and I'm sure they had a hot and steamy relationship after voyager returned home....ALLEGEDLY. The fact the didn't mention him at all is a slap in the face to Robert Beltran, as he made the character work and was one of the better characters from Voyager. All signs point to 7 just being straight up bi-sexual at this point, but it's sooo fucking forced.
Where the fuck was the development to even hint at a Raffi and 7 of 9 pairing? The only iota was Raffi saying that she respects what the Fenris Rangers do. That was it! If there were character development shown that portrayed a growing attraction between Raffi and 7 of 9, then it wouldn't have been nearly as bad. But no. It was an out of nowhere "appease some demographics" move.
While the Data thing was sad, and I did tear up from it as Data is one of my favorite TNG charaters, it was almost insulting to the character's noble and selfless sacrifice when he saved Picard right before the Schimitar blew up. Data had his emotion chip, and he could feel things. I'm sure in the 10 or so years he came to understand the various forms and concepts of love, and Picard was sort of a mentor and almost Father like figure to him. Thanks to the emotion chip giving Data the ability to feel 100% genuine emotion, I'm sure he loved Picard as a friend, and probably in a way as a father, and showed that love by sacrificing himself for the man that helped him learn what it is to be human far more than anyone else.
And what did they do? SLAPPED HIS ASS IN A FORM OF FUCKING PURGATORY...FOR OVER 15 YEARS. For data, that was probably several eternities, because if we go back ST First Contact, Data was tempted by the Borg Queen's offer for 0.6 seconds after she gave him real flesh and organic sensations, he said that for an android, 0.6 seconds is nearly an eternity.
So to try and answer your question about how can they keep fucking up star trek, I guess in a way, putting Data's soul, or something extremely like one, in a perpetual purgatory for countless eternities, I wish I could say that they couldn't possibly do worse than that to such a beloved and revered character...but you and I both know, they will cook up a scene or episode to fuck it even worse than that.
God damn this episode got me overthinking this shit way too fucking much. Punch me in the face and count to 10. Im fuckin out like a boxer in a coma.