Well, if my choices are:I'd argue otherwise. The research and development that goes into such endeavors pays huge dividends in other areas. It's money far better spent than on social media technology, weapons, or political lobbying.
a) Spend tons of money on colonizing space, that will never result in actually colonizing space, but will end up producing some really cool tech to be used in everyday life applications
Or
b) Spend tons of money on funding unnecessary foreign wars and whatnot
Then, yeah, I guess I would sort of prefer choice “a” if those are my only two options.