Ohhhhhh this opens a whole can of psychology worms. LOL
While Ubik has a point that today it is more accepted by the mainstream, I disagree to the degree. I think mainstream society is more accepting of certain types of Science Fiction - mainly that involving superheroes, but I don't see them really getting behind Space Based Science Fiction, with the exception of Star Wars which I feel falls more into a Fantasy Category.
Hmmm, I mean, it's hard to ignore just how popular the BSG reboot was, and that was very squarely a space based ship how. We currently have two active Star Trek shows, with perhaps more on the way. We have The Orville, which is cute misty eyed TNG tribute. We have The Expanse, which is absolutely epic Space Opera.
I mean, let's face it, no one is getting laughed out of a board room for pitching a SF show set in space. I really do think it's changed, perceptions are really different.
Time will create change. The whole table top / role playing angle is sooo connected to that. One need only look to when those games came into existence. Then look to who grew up playing them. Then look to who started gaining a hand in the influence of pop culture. I mean that can completely wrap up the argument. People who shunned those things in the past have been replaced by people who played them or were accepting of them.
With Space based Science Fiction I think there might actually be psychological issues connected with why people still don't flock to see Star Trek or something closer to a more believable future for humans in Space. On the flip of that they seem all too ready to watch things that involve our future near extinction by things from Space or by other means. They don't want to see a new Space Opera, but they do want to see how we fight back against the Aliens or Zombies that nearly killed off the human race. And they will go in droves to see humans who have superpowers in Space or wherever else.
Ahhh, now if we are talking OPTIMISTIC space based shows. That's another matter, I kinda hate how Picard was made all edgy and nu-trek. But, I dunno, I think the Expanse has a certain wide eyed optimism at its core even if it deals in dark and light.
Basically, I see it like playing Magic The Gathering. When I was a teen, you were seen as a total nerd, now it's a pretty normal thing and you won't get laughed out of the room for it.
I think, if someone had the vision and audacity to pitch a new space opera, it'd have a good chance of getting made. I guess the Expanse is a good example that people still want this stuff.