> High resolution photographs of the entire earth
We already have this, it doesn't require being on the moon.
> There's water on the Moon; we could have bases there by now, even if they were limited in functionality and size, like the ISS.
The scale of going to the ISS versus the moon is massively different. Most of the research we'd be doing on the moon that isn't just for robots to do like digging in the dirt could still be done on an orbiting space station (like, how to mitigate effects of microgravity on the human body, how to cultivate plants in low gravity, studying microorganisms and chemistry in space, etc.)
> We could have remote-control or autonomous moon rovers and bipedal robots exploring there 24-7.
This doesn't require a human presence on the moon. We've had nearly uninterrupted robots on Mars for decades and haven't had a human on it.
> Instead we have Moon landing denialists one one hand
You had moon landing denialists even right after we landed. Us continuing to be on the moon isn't going to get rid of these naysayers. People are arguing the earth is flat, that anthropogenic climate change can't be possible, that the earth is 40,000 years old, and vaccines are mind control agents.
I get it would be cool and there probably is some science that could only be done with humans on the moon that I don't know about (I don't know everything, for sure). I think it would do a lot to push our engineering forward to have this kind of constant investment towards operating in space. But outside of being a means to funnel public funds to engineering firms to essentially find cooler ways to burn money I'm not sure it's all worth it.
Not saying we shouldn't have a space program! There's still lots we don't know about the universe and lots of cool science to learn. But do we need actual humans on the moon to achieve these goals?