That was poor old officer Murdoch. He's family were not happy with Cameron after the movie.
I have read that no bodies were recovered with gunshot wounds.
The pistols were on the ship to keep trouble makers In line during the voyage. I hardly call (or think) passengers on a sinking ship were (are) classed as trouble makers. I really doubt the crew took the law In to there hands that killed random passengers and themselves. Captain Smith and Officer Lowe had pistol rumor stories too!
As for J.Cameron could had gotten more things right---
The 1997 movie,James Cameron movie predicts Titanic breaking after the 3rd funnel (close to the 4th funnel) I always thought that was odd. Because the wreck shows It Is two equal parts, not one bigger than the other, and how many times J. Cameron went down to the wreck? and he got that wrong!!!!!!