If you don't give Barry's gun back to him, he dies ...but in exchange you get the most powerful gun in the game, knocking out a requirement for the "Starsenal" achievement/trophy. Note that you will NOT obtain the "Trust Him" and "I'm a Member of S.T.A.R.S." achievements/trophies if you don't give him his gun.