We have a big dog, a Glock under the bed and a Remington 870 in the closet.
Bad idea with kids in the house, perhaps the shotgun with birdshot in it would be the way to go. The thing to remember about a gun, besides being potentially lethal to kids in the house, is if there is a breakin and a wife home alone does have a gun, she has to be prepared to use it effectively , there is no guaranty the bad guy won't get it from her. It's essentially throwing a gun into a her vs. the intruder(s) contest with the victor getting the gun.
Can't go wrong with a dog and a good neighborhood watch.