Best weapon for Concealed Carry advise

DIY yes I am very familiar with the event mentioned, we use it as a classic illustration during our training events to reinforce what we are teaching. We teach church and school safety classes regularly. In fact it is one of our most requested trainings. Funny you mention situational awareness, that is one of the key concepts to defensive shooting. I just did not want to become “that guy” and derail the thread by going into instructor mode! Hah! Full disclosure I am a certified defensive firearms instructor, in conjunction with a multitude of other NRA instructor tabs plus time overseas as a Marine in some unfriendly locations. Not counting competing at a relatively competent level in several disciplines. I may not be the worlds best expert but I am still alive.
first off, thank you for your service

secondly, i cant speak to for the OP, but i for one will take all advise i can, especially from someone who may have first hand knowledge

i understand that the main question here was "best weapon" but it seems to me each weapon is only as good as its operator

a .50 call hand cannon may have better stopping power then a 9 MM but if you cant fire the hand cannon without knocking yourself out, perhaps the 9mm is the better choice

?u=https%3A%2F%2Fwww.barnorama.com%2Fwp-content%2Fuploads%2F2020%2F03%2FGun-Fails-2.gif