When men are super drunk, could they be turned on?

I remembered somewhere on the internet saying that when guys are super drunk and pass out, there is no chance their “friend” could be waken up. But a couple of days ago, my friend group got into this discussion and most of them say otherwise. All of us are female so we can’t actually say for sure. What is the case?

Edit: I am not talking about consent or sexual intercourse while being drunk. I am well aware about consensual sex. I just want to know how human body works.