I actually plan to break it in and take a few classes and then never touch it again unless I need to.
First part, great idea. Last part, bad idea, but others have covered why, so.................
Let's look at your reason for a second...."never touch it again unless you need to." I think this is code for your wife, and maybe even YOU, for justification to buy a gun in the first place.
You think it's prudent to be able to defend your house and home and a gun, with training, is the best way to do that. You're correct.
BUT, you and/or your wife also think that it's "wrong" to like guns, or to practice with them ("what, you mean you actually
practice for killing people? What kind of guy are you?!") Or you fear that your friends may think you're a bloodthirsty maniac because you own a gun.
To start off, you must be honest with yourself. It's
OK to own a gun and to get good with it. Screw what anyone else thinks.
Which is better, a hammer or a saw? It depends if you want to cut wood or pound nails, right? A gun is a tool, nothing more, nothing less. Suit the tool to the job.
A compact 9mm as your only gun? Not the best choice, as smaller guns are harder to shoot well. Yout want it "very concealable." Why? Are you going to carry it on your person? If so, then what's up with the "never shoot it again" crap?
if you're not going to carry it, then get a larger gun. Several good brands and models have been listed, but that's not the problem.
I once had a similar experience. I told my friends that when I got my .22, I'd learn how to hunt rabbits and squirrels "in case I ever had to, I should know how." Once I learned how, I said, there'd be no reason to keep doing it. That seemed to satisfy them. The reason I made it rabbits/squirrels is because most people would not be as understanding if I said I was going deer hunting. (Bambi and all that childhood brainwashing) When the opportunity to hunt arose, I discovered............I liked hunting! I also grew older and matured and realized that, no matter what, not everyone likes guns, hunting or football. Screw 'em. It's legal, this is America and, by golly, owning a gun is a RIGHT.
The real problem is, you haven't come to terms with yourself yet.