As a former competition shooter (.45ACP), I do have some insight into handguns
Then what exactly are you afraid of?
The FFDO's jurisdiction extends aft to the cockpit door only. He only draws his weapon if someone has penetrated the hardened cockpit door, and he believes that the lives of his passengers are in danger.
If an FFDO draws his weapon you are already having an incredibly bad day - the worst day of your life, and maybe the end of your life. Why, if you are familiar with weapons, would you not want one in the hands of your flight crew at that point? What are you afeared of? Stray bullets?
May I suggest that stray bullets will not be your biggest problem at that precise moment.
(And by the way, if you fly in the states, you already have guns on board: FBI, local police, POSTAL inspectors, AGRICULTURAL inspectors, Treasury... I used to fly into a city in Georgia near the FBI "Club Fed," and it was not uncommon for a majority of the passengers to be armed....)