I've answered this one so many times, I should make a macro so I can just cut and paste the response.
Carry what you want to. Talk yourself into whatever is convenient. Tell yourself it will work just fine. But if I am advising anyone who I actually care if they live or die, I will tell them, to suck it up, eat some mac and cheese, find a used .38 or G-19.
All pistol bullets suck. In going with a tiny one, you are saying that even though all pistol rounds are inferior for the job, you are just giving up and using the most convenient one with the lowest likelihood of actually stopping the bad guy from doing what he is doing. Even though tiny guns are difficult to shoot, because there is less to hold onto and a shorter sight radius, and it's very difficult to actually get good hits when you are fighting for your life with ANY handgun, you are resigning yourself to the one that is least likely to actually put a bullet where you need it.
The "I wouldn't want to get shot by it" argument is gibberish. I don't want to get splashed with cat urine either, but it's not likely to force me to break off an attack. A better question might be something like: If you have to CHOOSE a bullet to get shot with, a .25....ANYTHING, or a 9mm JHP? Or ANY service caliber? Which one would you pick, hoping it would do the LEAST damage, and have the lowest likelihood of penetrating deep enough to hit something critical?
Do what you want man. It's your keyster.