Watson may have fired a gun a few times in the stories but it was never of any consequence. The one time a gun came in handy — "The Three Garridebs" — it was Sherlock who wielded it to rescue an incompetent Watson. Watson served as Holmes's "muscle" in concept but not in practice.