I think the air rifle worked in the video clip because it fired a bullet travelling at a pretty good speed and that bullet hit the hog in a sensitive location. I couldn't be sure, but it looks like the hog was hit in the head.

If you are hunting, I think in almost all cases, you are aiming for a sensitive location. Otherwise, you run the risk of the prey running off and either getting away entirely or suffering. Hitting the point you are aiming for takes skill.

From what I've read, almost every species of critter in North America has been killed using a .22LR, including moose and grizzly. I wouldn't want to set out with a .22 to hunt any such animal, but it could work.

As far as taking joy from succeeding in hunting, that doesn't shock me in the least. I'd expect it in many cases. Most people I know who hunt do not need to do so to feed themselves. However, if one just kills and does not seek to make use of the animal after it is dead, then something is wrong, imo.