The one problem with guns like that is that the pumpkin must leave the barrell intact.
IIRC the guy who shoots 'Second Admendment' grows his own hybrid pumpkin that is amost all shell, which allows him to achieve the high muzzle velocity without destroying the pumpkin.