A PCC makes a lot of sense for the two of you, IMO. I like to say that if carrying a rifle, it might as well shoot a rifle caliber, but definitely see the advantages of a PCC here.
I have a Ruger PC9 and recommend it. Recoil is light, there are plenty of sighting options, it has a short piece of rail in a good location to easily mount a light. Most of all, the noise and muzzle blast are minimal for the results.
Shooting a .233 in confined spaces is miserable for everyone.
The sights are close to the barrel, so close range boreline/sight line hold off is so slight it can mostly be ignored. That's an AR/etc house gun point that often gets overlooked.
The only complaint I hear about the PC9 is that it is heavy. I suppose it is compared to some 9mm carbines, but it isn't heavy for a carbine in general.
And it's not like a home defense gun gets carried far.
It feels and operates a lot like a 10/22, so if you have one of those and your wife has shot it, she can shoot a PC9. You can use a 10/22 for cheap practice.
It's often illuminating how easy it is to shoot. I'll be out practicing with pistol for a while then bring my PC9 out for a little bit. My first shots might be a mediocre effort but easily top my best work with the pistol I've been shooting all day.
As I said: Illuminating.