The Goliath Water is the same hotend as the Air variant with the heatsink swapped out for a water block and fittings. Everything else — meltzone, heater, heatbreak, nozzle thread, mount pattern — is identical.
The reason to choose it over the Air is sustained high-speed printing. Air cooling works until chamber temps climb or print speeds push sustained flow rates past what the heatsink can dissipate. Water cooling raises that ceiling. For VzBoT builds or any printer already running a water cooling loop, it's the natural choice.
For standard Voron builds that aren't already water-cooled, the infrastructure cost is significant. A pump, reservoir, radiator, tubing, and fittings add complexity and cost that most builders don't have headroom for. The Air variant covers the vast majority of use cases. The Water variant is for builds where it doesn't.