Yes, saltwater intrusion is caused by overpumping. The freshwater sits on top of the saltwater in essentially a lens. if you overpump, you destroy the lens and get mixing of salt water and fresh water. Unfortunately it can take the lens years to recover once that happens.
Thanks for a more precise description.