Bear spray vs. light weight handgun. Bear spray = no recoil. Light weight big bore handgun. Of course, from a keyboard anyone can handle the recoil.
I have seen lot's of used .44 Magnum revolvers on dealers shelves that have only been fired 3 times. By that I mean 3 rounds. Before you spend a lot of money, see if there is a range near you that has rental pistols that your son can try. If it hurts to shoot it and he can't hit anything it won't be of much use.