Failure progression rate varies. If the bearing starts to fail, it can allow the seal to lose contact resulting in a slow leak but that is only one failure mode.

All modern water pumps use a spring loaded face seal. Many have a rubber diagphtam that once it tears, complete failure is rapid. If the rubber ring around the seal seat degrades, the leak will start out slow and slowly get worse.

In short