Ok, I have a science background in medicine so, not astrophysics or chem, so wondering if anyone can ELI5+ me…

We’ve been studying in detail, the Moon, and even brought back soil, new LiDAR-esque water discovery types of missions, other countries contributing and it is certainly not obvious that there is appreciable water there. Even if “locked” into other forms and or molecules.

At this point, are we barking up the wrong tree? Is there confirmed amounts of water that would even be any benefit, at scale <<<<< key concept <<<< to make any type of industry feasible?

Mars, does appear to have had, historically, an ecosystem of water in appreciable amounts, but my opinion based on all discoveries is that all feasibly useful amounts of water were blown/evaporated into space along with their prior atmosphere.

Do we have any astrophysics type of folks out there able to say, there is definitely enough water or sources of minerals that can beget copious amounts without destroying yet another heavenly body? Else, “we will” become a “planet killing” aliens species, not altruists as Musk would have you believe.