There's one episode of Discovery I remember the most about - it was an early season 2 episode. But even then I can't tell you any dramatic impact it had one me aside from "I wish they did more stories like this."
And it was a Pike episode that would have been the stealth pilot for SNW if they'd planned it all along. And it also manages to be the one episode that contradicts the big reveal of the main plot later on. I'm glad they decided to make more stories like that, specifically a whole show about it.
If your one episode was "New Eden", I mean. Mine was.
My only objection to that is that people by and large aren't upset about gay and black people being shoved down their throats - just the blatant disingenous nature of it being performative and fake. You can only have so many "first ever X in Y" celebrations before you realize that none of this is new anymore and people need to start focusing on good story telling once again instead of being dishonest about the representation.
It's stuff like that the general audience is tired of because it happens EVERY time. Couple that with the fact that out of the gate her entire premise is based on being a space Nazi, I'm not sure how that really plays into "representation" anyway. [Note: I don't care about that because it's a fictional character in a fictional world, but some people get really upset about fiction sometimes]
As I said above, there will always be a small segment of vocal people who will love it or hate it no matter what - but I think the general audience can see through the bullshit on either side.
There are certainly some cynical parties who are only interested in profiting off the optics of seeming inclusive, but I'd generally associate that with the ones who don't follow through. Like how Disney manages to get articles talking about the first queer character in the Disney lineup every other movie they do, because someone kisses someone in the background of a shot that's going to be cut for China. And the next one always still gets to be the first time again, precisely because all of the other ones so far were exactly nothing.
Thing is, movies still have China and TV shows still have Trump moms. Companies want to seem progressive, but they still don't want to poke the wrong bear and end up with people burning their Nikes. So for shows like the recent She-Ra cartoon to exist, it was actually a constant struggle between the creator and higher-ups just how much they were going to be allowed to include. In that kind of situation, it's in everyone's best interest to market the ****
out of how progressive they're being. The company, again, wants to look
progressive. If they're worried they're too woke for a boomeral audience, they're going to double down on trying to draw in as many progressive viewers as possible with the idea
of inclusion, while keeping the actual content as generally milktoast as possible. The creators we're worried about tend to be more progressive than the networks or studios, so if they want more inclusive stories and characters in their story, the best bet is to motivate the audience to show support for it. That's why that Buzz Lightyear leak happened, because one of the creatives knew that audience backlash about the company cutting an explicitly gay scene would be enough to make them regret or reverse it.
When it's something like Disco having the first literal and explicit trans characters in Star Trek ... yeah, you're going to have to market that shit. Because the company knows it's taking a hit from one audience in hopes of picking up another one, and it's going to want to see its RoI. (And of course, Blue Hair and Pronouns have been handled poorly in some aspects, but surprisingly not to do with their literal transness. Adira's pronouns scene and Gray's mole scene were just about the only places it's come up in the script, and both were pitch perfect. They crashed and burned on Gray's also-metaphorical trans thread and a part of me will never stop cringing about "truly seen", but I chalk that up to Discovery's general badness intersecting with its general diversity mandate, not the diversity itself enabling badness.)