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.