The first thing, and I think your post shows that you've done this, is define the purpose for your new firearm. That sets up your requirements. Buying a gun without regard to requirements is fun, but in your case, a waste of money, because you do have a couple of requirements.
The next is to get some training. The suggested range looked great. Learn to shoot, learn to shoot well.
Then learn when you can, or can not, shoot. The law and legal principles are a critical (and often overlooked) part of gun ownership.
With some familiarity in firearms, it's time to try the various types out. Go back to your purpose - what you need the gun to do, and make sure your choice in firearm fits your requirements.
Some guns are great for concealment, but small guns can be hard to shoot, and you wanted one to target shoot. Small guns hold fewer rounds, limiting their effectiveness in self-defense. Revolvers are beautiful, easy to operate, but only hold six (sometimes seven) rounds. A semi-auto pistol holds more, but you have to learn to manipulate a slide and magazine. A rifle or shotgun is easy to aim, easy to manage, but you wanted to fit this in your car, which is impractical with a long gun.
Like choosing a new vehicle, there are a bewildering array of choices in firearms.
You need to shoot an example of your choice before you buy. It's like a test drive on a car. What feels good in your hand at the gun counter may not work for you under recoil. Find a range that rents, and try a few out. There are lots of very good guns out there that meet your requirements, your budget, and your budget.
For my money, you simply can't go wrong with a Glock 19. There are guns that cost more, some that cost less, but none are more reliable. It is the most common gun in the world for good reason.