Getting water in space for making fuel and oxygen, drinking, sanitation and growing plants will be way more sustainable than lifting water off of Earth for use in space.
Water is an absolutely essential resource but it's heavy and it doesn't compress (you can't make it smaller to fit on a rocket). Lifting water mass into orbit is ridiculously expensive in terms of rocket fuel and vehicle use.
The moon is a dead rock. There's no ecology to disturb. It's nearby (comparatively), and a much easier target to land on than an asteroid, but also relatively easy to take off from again after you've landed. We should get water there if we can.
The problem is that in gas form hydrogen and oxygen take up more volume than they would as liquid water. To store them compactly you have to cool them to liquid, but that requires a bulky and power-hungry refrigeration system.
Also, hydrogen is a nasty thing to try to store in pure form. You have to deal with embrittlement. Hydrogen has one electron which it easily gives up to form a chemical bond with whatever happens to be around... such as the walls of the storage vessel or the seal around the valve or whatever the valve is made of... and that bond degrades the integrity of the container and eventually it leaks, and then you have a pure hydrogen leak to deal with. Most applications that need hydrogen try to generate it as close to the time of use as possible. Trying to keep pure hydrogen in a tank sucks.
Hydrogen + oxygen is the most energetic chemical reaction you can get, which makes it effective for rocket propulsion. But there are other fuels used such as RP-1 (refined kerosene) because they're less of a PITA to deal with than hydrogen and depending on your rocket design you might get better efficiency if you don't have to carry the extra weight of the hydrogen cooling and storage system.
Sustainability loses it's meaning in space, or needs a whole different meaning. There are no ecosystems on other planets or moons which we could tip over with unsustainable practices.
Just throwing this out without addressing the glaring differences looks like uninformed romanticism.