Do you really disagree that it’s advancing science? Surely actually testing hardware, building knowledge on how to run this type of mission, learning to use lunar resources, figuring out how to keep people alive, etc. will teach us things we couldn’t learn any other way.
Fwiw do share your concerns about the methods (sending humans on this specific mission is questionable, SLS is questionable compared to SpaceX approach).
Do you think we will learn more from Artemis or the Asteroid Redirect Mission? Because that's a concrete example of how funding this mission caused other experiments to be cancelled.
It's not science, it's engineering. I don't think it's advancing science in a way that wouldn't be possible with a fraction of the cost without sending humans there.