.40 vs. 9 is a complete YMMV situation. I think calling one over the other for supremacy is a little asinine.
.40 or 9, neither shot is going to be your Hollywood Movie "guaranteed one shot and he drops" round.
There has been documentation of 9mm bouncing off of everything from denim jackets to car windshields, if you're willing to listen to those police reports.
Short of changing standard issue firearm to a bear or elephant gun, I expect to eventually see this argument being re-hashed again.
My opinion is that a lot of individuals, LEO or not, are sorely in need of training as to the realistic expectation of small arms. Never been "one man army guns" and probably won't be any time soon.
Human beings have survived large caliber head shots, severed limbs, explosions, and even nuclear attacks. Not all humans blow over like an unhinged screen door.