Perhaps, but the best scifi kept that kind of thing secondary and very much in the backgroud.
Look whats happened to both starwars and startrek now people who want to force their agenda have got involved. Both have become sad parodies of the older stuff.
The agendas you speak of were always there and always in your face.
Plenty of TOS and early TNG episodes, where Roddenberry was directly involved, were at least as blatantly progressive as anything in recent shows and often much more so given the norms when they were produced.
Much of the newer material is a sad parody of the older stuff, not because of any multiculturalist egalitarian socialist utopian agenda, but because that's not even the agenda any more, it's just a veneer over a product, meant to maximize profits with the minimal amount of work. With the older shows you could tell people were taking risks because they believed in something and wanted to tell a good story.
Got to disagree here, the best Sci-fi holds a mirror to the society that creates it, surely?
Even newer stuff does this well. It's shows that society is largely made up of a pile of vapid, delusional, consumerist, bigots.
What do you make of the borg? Your culture will adapt to service us? Resistance is futile and all the same colour. Some might think it was a metaphore for multiculturalism. Bad guys...
The borg are a singular culture, that forces everyone they encounter to adopt their ways, and were highly intolerant to the point of genocide of all other cultures. That is exactly the
opposite of multiculturalism, which requires tolerance of differences, rather than forced assimilation.
The borg are a metaphor for fascist nativist cultural/racial supremacists.
For me personally i enjoy a bit of fantasy to escape from reality. This is why the agenda is so unwelcome and perhaps why some felt the need to push it. Take DS9, it was all there if you chose to look for it and yet it managed to do so in a completely non triggering way.
Maybe it's less the apparent agenda that triggers you and more the bad writing, gimmicky characters, plot holes, and lens flare?