Yep, seen that happen enough over the years. If the car has a fan attached to the water pump, it may be out of balance.

If not, it is likely the bearing lost grease then the shaft weakened or the material was too soft. Modern water pump bearings use the shaft as the inner race for the ball bearings rather than a packaged ball bearing on a shaft.