The nomination of the billionaire entrepreneur, private astronaut and Elon Musk ally was before the floor of the Senate when the president abruptly withdrew it in June.