For decades, the faintest hint of cosmic pessimism has been limiting expectations if not dreams. Now, we're in the midst of a new space race