Many motherboard pump headers will still provide power while in sleep. But you usually start hearing the pump more when it’s older and the bearing starts to wear, or due to permeation lowering the water levels.

If you have a watercooled system getting less hours on the pump is always good, especially with a cheaper AIO. Also not all pumps are completely quiet when in sleep