My real wonder would be if the majority of Americans would okay the amount of money it would cost to save that one man?

Depends where the money is coming from. Military budget? Absolutely. Being taken from social services and whatnot? No. The amount of money that would cost could save so many more lives if it was used for things here. Choosing to spend it on saving an astronaut rather than on, for example, feeding homeless people and distributing medication and disaster relief is like a version of the trolley problem where the trolley is already heading for the 1 person, but you have the option of switching it to the other track to kill more people if you want to. I’d have a really hard time calling that moral by any metric.