The overall rule: most US military spending is utterly wasted to line the pockets of politicians and the military-industrial complex. It's not useful even for defending the country.

The exception: there will most likely be something useful coming out of a space program. May or may not be useful enough to offset the costs, but it's not going to be a complete waste.