I disagree, John Watson in the example is not a person you’d expect to store a gun in a drawer on. Any former or current law enforcement/ army people who own a gun for legitimate reasons would not just have it in a drawer. People who have guns in drawers either want to show off or protect themselves against (other) criminals, neither would make sense for his character. Him having a gun is one detail, him not storing it safely is another.