It's still pretty dang abundant, though, is it not? Ceres is literally a giant ball of water ice. So is Pluto for the most part (it's even hypothesized to have liquid water under its icy crust). So are most asteroids and comets and dwarf planet(oid)s and gas giant moons. There's massive amounts of it in both Uranus and Neptune.

Like sure, it ain't like 19th century fiction books where space is literally an ocean and the latter part of the word "astronaut" is far more literal than it is now, but water is by no means scarce in the solar system or in the universe as a whole as far as anyone can tell.

If anything, everyone thought water would be less abundant in the solar system than it really is.