Plain-English answer
Cavitation is vapor bubbles forming and collapsing where they should not.
When pressure drops too low inside part of the pump, the liquid can form vapor bubbles. When those bubbles move into a higher-pressure area, they collapse. That collapse can create noise, vibration, pitting, heat, and equipment damage.