It's a common perspective. My personal experience (working in the defense sector) is that these kinds of endeavors end up tieing up a lot of very smart doing vanity projects that in effect don't "generate value" for society. All the people involved wouldn't just be sitting on their hands if the moon project didn't exist. But I guess it could be worse.. they could be working on moving money around or pushing ads on to people