You can always shoot up in the air. . .like ol’Uncle Joe Biden says (firearms expert he is).
Just trying to compare a .22 with a .223 shows me you are a rank amateur and probably should not even own a gun.
It’s like—should I buy a Moped or a 1/2 tons Chevy PU? Both will get you to work.
For serious house defense a KSG or a Super Shorty.