i really dont see what active shooter scenarios you guys are thinking of where a ccw would engage at 25+ yards.
Unless you have everyone following the script in your mind, not everything might happen up close. Lots of open (and not so open) space out there, and in places you might not think of as "long distance".
When was the last time you paced off the distance from the front of the mini mart you always go into to the back? How about the supermarket isles, or across the front of Walmart? Parking lots? Out in the yard?
Planning on one narrow set of scenarios or what the stats tell you are all you should be worried about, is panning to fail in my mind. Hence my comment above about bringing the right gun along (I carry a full size gun, the smaller guns are back ups).
Things like the 42, or P238, etc, that have good sights, make longer range shooting more doable, but still require you practice shooting them at the longer distances to know what to expect. You have to do so in little more realistic manner too, and not just target shoot. I know more distance usually means more time, but not always, and you should be practicing to shoot quickly and accurately. Can you reliably and repeatably make good hits with that little gun shooting that way?
Then theres the caliber issue. .380 seems to be considered barely usable by many at contact distances, how is it looked at at longer ranges?