Comparison between measurements, simulations, and theoretical predictions of the extraction kicker transverse dipole instability in the Spallation Neutron Source