From a response made to a similar OP in 12/19
"Late to the party. Most respectfully: a reload is highly unlikely and would be too slow to be outcome changing-
manipulation on any firearm is going to be a real challenge- recoil for any follow up shots at speed is going to be a challenge-
any malfunction clearance in an auto loader is going to be a real challenge- therefore a tuned .22 revolver- S&W Model 317 or Model 63. Both have 8 shots."
Edited to add
perhaps a .22 caliber 10/22 etc with a red dot as it is never going outside of the house as per the OP.
different ammo lots to minimize rimfire malfunction issue
the ideal solution here is not likely to be particularly inexpensive relative to telling someone to buy a Glock police turn in and rocking on.