You should go with a .22LR revolver. Perfect to get used to training with (unless you have shot before) and super cheap ammo.

You can pick up a Heritage Rough Rider for under 100$ or Ruger Wrangler for about 200$.

Guns are like tattoos. You go decades without them, then get one and all of a sudden feel the urge to get more 😂