Earlier quoted context omitted.
Do you have any idea how many areas of science were opened up by our attempt to get to the Moon? The range is literally from discovering that unit tests are good in software to discovering the Van Allen belts to learning about the geology and history of the Moon from the rocks that we brought back. Could we have learned more science by doing something else with the money? Of course. But it is a dramatic overstatement…
Yes, and I tell you very few if any. If you don’t believe an anonymous person here, see what prominent physicists say clearly on this topic, e.g., Steven Weinberg. This is not to dismiss experimental research which is quite important, but to distinguish (experimental or theoretical) science from product development.
In https://www.thespacereview.com/article/1037/1 you'll find that he is very critical of manned spaceflight in general, but about Apollo he says, "No, at the time of Apollo, the astronauts did do some useful things. They brought back Lunar samples. They placed a laser reflector on the Moon that has been used ever since to monitor the motion of the Moon with incredible accuracy."
Earlier in the same interview he criticized NASA for canceling Apollo 18 and 19 because he wanted the science that would have been done, to be done.
I guess he didn't say what you thought he said.
That said, his criticism of NASA's efforts with manned flight isn't because he doesn't think that it is useless to go to the moon. It is because it takes a lot of work to get humans there, and robots can do the job much more safely and cheaper. Which also explains why he thought Apollo was useful. At the time the technology of robotics was much worse so humans were the only way to do the job.