You can find plenty of critics of Big Science and/or government spending on prestige projects,

Those people generally claim that Apollo was a waste of money period, not that Apollo was a waste of money compared to going to the moon via the normal grant process.