I'm not quite sure what the OP is saying – that if there'd be a popular space science fiction show in the early 2010s then we'd have sent astronauts to Mars by now? I don't quite see the connection – no matter how popular a TV show is, it's not going to make politicians change their minds and give space agencies lots more money.
Science fiction on TV has always been quite cyclical anyway. After the original Star Trek ended in 1969, I don't think there was another space-based science fiction show until Space:1999 in 1975, then the original Battlestar and Blake's 7 in 1978. Then after those shows, nothing springs to mind until 1987 and TNG. So we've had lulls before.
My advice: if there's no good TV shows, then read a book. It's where most of the best science fiction is anyway.
I think in order for a Space Based Science Fiction series to find success it would have to focus on the aspects of interpersonal drama, sex, and action while toning the Science Fiction way down.
I don't quite agree (though I know what point you're making, that science fiction places more emphasis on high-concept ideas). The best science fiction is about people (or aliens that look like people), and stories about people are invariably about interpersonal drama on some level. It's why sometimes Star Trek can feel a little stale because of the Roddenberry edict not to have the crew arguing, and why the best episodes of Trek were often when McCoy and Spock are arguing, or Odo and Quark are put together, or some guest character comes aboard the Enterprise to stir things up with the crew. Nu-BSG was practically built on inter-personal drama, and B5 had plenty too, though the stakes were usually much higher.
I think The Walking Dead and Game of Thrones achieved their highs, in terms of audience popularity, because of a combination of things that happened all at the right time. They both genuinely gave us things that we had never seen on TV before, so they felt 'new' (a rant I'll get onto in a minute). They also came at a time when it was starting to get cool to like nerdy things– the stigma Looney mentions was starting to fade – if you didn't watch WD or GoT, you were suddenly 'un-cool' and were perceived to be missing out on something culturally important. And finally, they came on the scene just before the advent of streaming TV, where frankly there's too much choice and nobody subscribes to all the streaming channels, so I'm not sure if any TV show can genuinely become that big again simply for that reason. For All Mankind might be a really good show, but lots of people like me don't have Apple TV, so won't get to see it. Ditto I've not seen any of the Star Wars shows because I don't have Disney+. The Walking Dead was on Fox, which I think lots of people could watch? And GoT didn't do anywhere near WD's viewing numbers, despite it's popularity, because it was on HBO (or Sky Atlantic over here in the UK). I think more people watched pirate copies!
My main problem with TV space-based science fiction now is that very little of it is new. We've got more Trek sequels, more Star Wars shows, yet another BSG reboot, a B5 reboot, shows based on computer games like Halo or on books like The Expanse or comic books. Even WD and GoT were not new ideas, even though what they did on TV was revolutionary. Where are all the genuinely original TV shows that aren't based on anything that has come before? There's the Katee Sackhoff show on Netflix which admittedly I haven't watched and probably should before I cancel my Netflix subscription; before that there was Killjoys and Dark Matter, neither of which I could get into. Even Dune, which I think represents the great new hope for science fiction cinema, is based on a book series and has been filmed before. And it'll probably spark a flurry of adaptions of science fiction books – Denis Villeneuve has already optioned Rendezvous with Rama. Where are the good original screenplays?