Projectiles that pin-wheel.. Hmmmm.. You’re onto something.
You have to disrupt the upper atmosphere, not the funnel. Otherwise it reforms. That is hundreds of miles of sky, thousands of feet ‘deep’.
And maybe something that doesn’t fly very efficiently, too but would have to survive the beating. And the energy would have to go somewhere. Converted to heat from friction and wind resistance?
A ton of energy though.