Lost... you just made a bad first impression on the forum... you can recover from this... the more we get to know you, the more we'll realize you're not this way... so relax.
Depending on your age and experience... it's understandable that when it became apparent that sex could be a 'possibility' you became excited. However, it was her choice to refuse... no need to feel badly (or let down) for it.
No, you're not a loser for being unable to score with a drunk chick. Declining a drunken woman's advances is the more honorable thing to do.
Read a few of the posts on here... ask a few more questions... can only help to expand your understanding of relationships and women...
"The weakest soul, knowing its own weakness, and believing this truth that strength can only be developed by effort and practice, will, thus believing, at once begin to exert itself, and, adding effort to effort, patience to patience, and strength to strength, will never cease to develop, and will at last grow divinely strong."
- James Allen