Like the drunken Russian soldiers we get to see dieing? In other words: I doubt it. Is there actual proof for this happening? If so, how would the effect of alcohol be countered?
There’s tons of study on both alcohol and adrenaline’s effects on the body. As far as a study about sobering up because of adrenaline, a quick search didn’t yield any. Probably because of ethics concerns I’d imagine. But judging by the votes, a number of people have experienced this first hand.
I'm sure it worked the first few times. In a situation like that you'll be under constant stress, that's not at all comparable with suddenly finding yourself in an emergency.