To the average person, space flight is not so much boring, but simply over their head and complex. Actually, I bet it IS boring to them because they cannot connect at all, even though it may interest them. If you don't bring in the human element of intrigue, interpersonal relationships (good and bad), etc. into the mix then all you have is a boring NOVA episode that might be fun for science geeks and completely crap for everyone else. I mean seriously, what the hell do you people want? The NASA Channel is all about science, and it's ratings are through the roof...oh wait...no they aren't!
It's not about being 100% REAL, but real enough to get the imagination flowing. For Christ sakes, Star Wars and Star Trek are totally not real in virtually every way, but those movies and series' alone helped to motivate a crap load of people to become engineers and scientists, just to try and make Star Wars real, and we've had a lot of innovation because of it.
In the past it was all about books with sensational characters, now it's TV. Yeah, Buck Rogers was so real wasn't he, or Flash Gordon. Puh-lease, it's entertainment mixed with just enough plausible science that it could be used as a means to enlighten the public AND entertain them with respect to space travel. How the hell else do you expect the public to get behind something they generally don't understand?
Just look back at every single classic sci-fi comic or book from the past and you'll find elements of everything that was seen in this TV series, the only difference is that most of you are so stuck up (or old) to appreciate the modern entertainment demographic.