He told me he didn’t have a lot of confidence in the Sparrow. They eventually got some aircraft with guns but never used them; despite Top Gun school something like 90% Of his flights were ground attack missions.
The Sparrow had its own challenges from what I've read. Specifically issues with the acquisition radar being able to track a fast moving target and the missiles ability to receive the reflected signal and apply the right amount of correction. Got to remember that the time when these missiles were being developed it was to target slow moving bombers - not tight turning bandits.
https://www.amazon.com/Sidewinder-Creative-Missile-Developme...
The rest ... were a liability for years.
US pilots also had the bizarre order to visually identify targets before shooting (which then meant waiting 4 seconds for the missile to arm before actually firing it.)
Amongst other things, visibility in the tropics is often not 4 seconds worth, and the enemy can use clouds to get real close.