Nothing wrong with a pistol, I had all my batteries go down last game and I got a couple folks who had real long guns with pistol shots.
Make sure you can get magazines and accessories for the particular model you're after. If you have to get a soft cloth holster make sure you get a lanyard for when it falls out of the holster. It will fall out.
If possible try out different version at games, unless you are very familar with the real versions. Some folks swear by 1911s and other like a Sig or Glock type. Since they all run similar capacity and have the same caliber you might as well get one that you like the feel and controls when used.
Airsoft, where nothing is hurt but feelings.