The photographer realized they needed a gun in the picture but all they had was an air pistol.
I think the .25 auto only lasted one book until Q or M told him to upgrade to the PPK 9MM kurz because it had enough power “like a brick through a glass window” or some nonsense like that.
In Casino Royale he has .38 police special and Colt 45 in his Bentley.