I can see why the guy would do this. IMO the only dumb thing he did was to take a loaded gun in to a room full of children (if hes so experienced, he should know better). But everyone can have accidents. Even seasoned veterans, not that I claim him to be one 'cos I simply can't know. Shooting himself in the foot, thought sounds ridiculous, doesn't mean he's stupid. All it takes is one second (or more) of carelesness. And with a loaded one should not be careless, human being is allways unreliable.
Now if shooting himself in the foot wasn't embarressing enought, the video of this incident is released to circulate in the net. Yes he should be compensated for such monumental embarresment. Especially if it indeed has ruined his career. And yes it is up to the owner of said tape to do with it what he wants, but he should at least blurred the agents face.
I'd think shooting oneself in the foot is enought teach a lesson to be more careful. I think the tape is funny as hell. And I really think the poor guy has suffered enought.