A AIM-9 crashed into a MIG, didn't go off, got stuck, and reverse engineered after landing.
At the same time, a 747 and a MiG are two completely different vehicles.
An SM-2 has a solid chance of sinking a ship - and was seriously investigated for that application. A direct hit on a 747 is game over. It's going to go clean through, and if it's into the fuselage, cut it in two.
> For example, Dr. Stalcup obtained several FBI records never released to the TWA 800 families or the public. One described an “original [Navy radar] tape” showing an object “heading straight for TWA 800.” Another describes an object on radar “impact[ing]” TWA 800 and “spiral[ling] away,” while also stating that witnesses described seeing a “flair (sic) going up. . . . , orbit/circle another object. Subsequently debris fell from the sky.”
The reason for the warhead is to improve the odds of the bringing down the airplane.