Proponents of going to Mars see peril and opportunity in Elon Musk's close relationship with Trump. Experts say just getting Americans back to the moon in the near future will be challenging enough.