It stands to reason that the the next step (a semi-permanent moon base, progress towards being able to launch more stuff into deeper space) will provide similar benefits.
What they are against is giving untold billions to old Shuttle contractors to fly a overpriced single use rocket.
We will not get advanced technology from a moon program unless the moon program FINANCES ADVANCED TECHNOLOGY. This moon program is the opposite, it tries to keep old technology alive.
If you want a moon program that finances advanced technology, what you should do is build large reusable rockets that deliver small modular nuclear reactors to the moon. And also some drone/robots that build habitats autonomously. That would actually be providing technology benefits on earth.