On the contrary the average person in 1969 also thought that the moon missions were a waste of time and money: https://www.sciencedirect.com/science/article/abs/pii/S02659...

This thread is pretty much how people felt back then too.