Revealing the Microscopic Mechanism of Elementary Vortex Pinning in Superconductors