"IF" you find someone that's been in the situation, I doubt you'll get them to come out talking about it on a public forum. It's not a new computer game you got to play and in most cases, the person will never be the same when it's all said and done. The good guy gets to walk away but no one wins.
I assume the new member above posted the link as it's about as "real" as you can confirm about a situation like that.
BTW, In most of your examples, in-laws etc., there was a legal justification for self protection and has nothing to do with a CHL. I know, I'm nit picking.
You prepare as best you can but that includes preparing to avoid getting into that situation. But when you do, you'll find you cannot train for it; you hope your natural response system will be controlled and methodical.
And just because

.......the whole idea behind CHL is not self defense and especially not defense of others as we have no responsibility or obligation to protect anyone. At least as a first line of defense. Having a CHL gives us the ability to legally carry a concealed handgun. We're doing all we can to keep ourselves safe which includes running, if that's an option. At the time, we may be carrying a handgun which is a tool that we might be able to use to stop an imminent threat as a last resort if we can't ensure safety any other way.
We're not cowboys in the old west out looking for some bank robbers to shoot for the reward. Anti's love to hear CHL holders talk as if they feel they have power to shoot bad guys at will like the Hollywood hero's and it does us no good.
But to your question, it comes up from time to time but you'll almost never get real life stories unless it was a case of "almost" or "I thought about".