First, I would like to thank the devs for adding the Tommy gun to the game. I am looking forward to getting and using it. I'm not complaining, but since we have this and the shotgun, I would like to see handguns added to the game, as well. Thanks to time travel, the holodeck, Q, and other alien weirdness, we've seen handguns in use in several episodes of Star Trek, and in several different versions. I did some looking around the net to see which handguns were used, and in which versions of Star Trek. I found no information about handguns in Discovery. Here is the list of handguns and how many (other) versions of Trek had them.
M1911: 5 (All of them, 6 if you count "The Voyage Home" movie)
Walther P38: 4 (All except TNG)
Colt Single Action Army revolver: 3 (TOS, TNG, ENT)
Walther PPK: 2 (TNG, DS9)
Beretta 92: 2 (VOY, ENT)
The following handguns appeared in only one version of Trek: Colt Detective Special revolver, Luger, Colt Model 1903, Smith and Wesson Safety Hammerless revolver, Smith and Wesson model 10 revolver, Colt Police Positive revolver, Colt Official Police revolver, Type 14 Nambu, Colt 1860 Army revolver, HK P9s, and Smith and Wesson 15 revolver.
This is the information I found, but perhaps someone knows more about this than me, and can add to the list. However, please, let's not turn this into a debate about which guns are better. You can find that elsewhere on the net. Just saying, these were used in Star Trek, and I'd like to see some of them added to the game. Sulu had a collection of them. While I'm at it, can we also get a fedora?