As he prepares to bring the magic of space exploration to UK audiences, the veteran astronaut speaks about dealing with fear, Elon Musk's rocket triumph and becoming the only man on Earth to play David Bowie in orbit