>The social side was much less impactful
I'm not so sure.
I was once in a long conversation in which my interlocutor was trying to get me to support socialism during which my interlocutor asked me to envision a future society "like Star Trek" then looked at me expectantly as if he had some hope that that would bring me around or at least soften my stance.
Beyond inspiring enthusiasm for socialism, it seemed to have inspired an unquestioning support for technological development:
Consider for example this comment by someone (rayiner) who is certainly capable of subtle thought, but who believed it would be a good reply to worries about the effect of the current crop of AI assistants on the psychology of children to write, "it's literally like the computer in Star Trek": https://news.ycombinator.com/item?id=49326105
Or this comment by the same author in which he asserts that "we need to increase energy output by an order of magnitude in order to upgrade civilization to the next level. . . .
Nuclear, moreover, keeps us on the tech tree for space exploration. I don’t think solar is going to lead us to fusion or antimatter powered spaceships" (which most of us would judge to be at least a little reckless with the environment). An then in a follow-up comment writes, "getting us to a Star Trek future shouldn’t be a politically polarized issue". https://news.ycombinator.com/item?id=49820988
If Roddenberry's Star Trek (i.e., The Original Series and the first 4 seasons of The Next Generation) were merely more delusional than most works of sci-fi, we probably wouldn't be discussing it now. You and I consider it worth talking about because Roddenberry's Star Trek has had been extremely influential. I would maintain that that influence has been very negative: it is has made people more zealous and ideological -- and not just about socialism.