If only for in the home/on the premesis go with a 38 J frame or larger. The revolver would be better for wife and yourself. Get some 'mild' loads for practice--and do practice. 100 rounds/each/year.
Maybe some friend will load some lower power 38s for you. Id help you, on my equip, if you lived around here.