Whether successful or not, his attempt to do so will reshape America’s space programme