Makes sense from an evolutionary perspective. Your body wants you stay awake to get more water, but once you are asleep it tries to conserve as best as it can - - just a guess.
On the latter I'd guess simply not waking up from an urge to pee could explain it.
Personally, I don't drink water at night. Even a little bit. Because if I do, I wake up to pee multiple times.