Stormtrooper I'm surprised you don't know about Project Stove Pipe. They used the F-102 with some success against targets on the Ho Chi Minh trail. Using the Deuce's onboard IRST as well as the IR variants of the Falcon and the 70-mm rockets mounted in the weapons bay doors, they attacked targets such as encampments and trucks and pretty much anything else they could hit.
I don't know about Cunningham shooting an AIM-9 at ground targets, but USAF pilots flying the F-102 most certainly used their rockets and AIM-4's for this task. Unconventional though it was, they did have some success.
(Yet more ammo as to why the F-102 should be flyable!)
Show some love to the Deuce!