There have been lots of new releases of frozen water discoveries on various bodies. Typically in craters that pretty much stay in shadow. Water doesn't seem to be that scarce. It's just not as abundant as on Earth
The US Navy built a 2.5km/s railgun you could fit on a ship. A 3.5 km/s coilgun has to look like the Paris gun to be practical and be able to shoot at a high elevation to hit Earth-Moon L1/L2 or near-Earth space. A railroad car worth of material per day in 1kg or so increments seems plausible. A radiation shield for a deep space station or a simulated asteroid to test mining and manufacturing technology might compete with terrestrial materials.
O’Neill’s students never came up with believable catcher and I’ve yet to see one I like. I guess you could get to LEO if you could aerobrake but it looks tough because the outer atmosphere is always changing and a wild shot could trash your target, talk about a space junk problem.
The moon has at best a large glacier on it and my guess is Lunarians, if they could vote, would not want to export a gram of it but rather incorporate it into a circular economy.
Nitrogen needs a high-pressure bottle which is wasted mass, whereas water you can send to orbit in thin plastic and fabric bags like they do on ISS.
Often on ISS they're actually shipping oxygen as water, but still the wasted mass of water being 11% hydrogen plus the wasted mass of the bag is more efficient than a high pressure gas cylinder.
The water inventory of both N2 and H2O on Earth (0.2 cubic km of water per inhabitant) is extravagant. Ceres is roughly 50% water (like the generic outer solar system or interstellar object) and we could use all of it but it adds up to about the mass of our oceans, and that is most of the water inventory the asteroid belt.
I’ve looked at various large rotating structures up to the size of the Banks Orbital and concluded you could solve the structural problems if you could make a reliable journal bearing (structural parts don’t need to be spun) that could handle the velocity difference but no matter what you cannot afford tall mountains or deep oceans.
Very tempting to swap nitrogen for helium, but AIUI the main downsides are that the speed of sound is higher so air will leak out from a breach faster, and there may be negative effects on flammability due to helium's high thermal conductivity and low specific heat.
There have been proposals to use scoopers with structurally integrated electrodynamic propulsion ("tether without the tether"),[0] which would use zero propellant.
[0] https://forum.nasaspaceflight.com/index.php?topic=44542.msg1...