A special consideration for use of a weapon for indoors self-defense:
How many people besides you are in your home?
If you fire your weapon and miss, consider whether or not the type of weapon and the type of load in it will pass through your interior walls; and if so, who else might it hit?
RonF raises a good point. Consider how many people are, normally, in your house. Also, WHO are they? Does your wife share your interest in procuring a firearm? If so, she should be involved in the selection process. This is especially true if you are on a limited budget and can’t afford his and her’s firearms.
In any case, it would be wise to get her in on the conversation. Is she supportive, neutral on or against the idea of procuring a firearm? Find out why and talk it over as a family.
You also need to discuss the logistics of having a firearm in the house. How will you educate your child/ren about firearm safety? What steps are you going to take to ensure that the firearm is secured when it is not on your person? There’s a lot to think about. This is where an NRA first steps course could be useful.
My wife and one infant, and yes, shooting toward an intruder coming into my bedroom would head toward my daughter’s nursery, so that’s an excellent point!