Why pressure rises with depth
Water pressure rises because every additional metre or foot adds more fluid weight above the point you are measuring. That hydrostatic load is then added to the atmosphere already pressing on the water surface.
This is why divers often use the rough rule that every 10 metres of seawater adds about another atmosphere of pressure. The exact value depends on density and gravity, which is why fresh and salt water are close but not identical.
Pabs = Patm + ρgh
Absolute pressure equals atmospheric pressure plus hydrostatic pressure from the water column.
Pgauge = ρgh
Gauge pressure at depth excludes the atmosphere and keeps only the water-column contribution.