Help! I think I may have blown my chance with a guy friend.?

If he's pulling away from you, you've nothing to lose by just asking him if he's ever considered being more than friends. If he says no, well, tell him you are happy to be his friend. But if he says yes, it will be so worth it. If it has not been long since your drunken incident, give it a bit of time.