>that money could absolutely be spent better in other ways.
It can't. The amount of money allocated to the space program is insignificant and doesn't move the needle. There are diminishing returns to putting more and more money into the same things. By investing a little into every sector you diversity and pick up the low hanging fruit.