Is it normal or do i have no standards?

I met this guy online a few months ago (not on a dating site). we talked every day since and earlier this week we decided to meet. So I met him and the meeting went great. we had a few drinks at a bar. unfortunately, because we were doing so much talking he missed his bus home. At this point, i had no real reservations about letting him stay in my spare room as I just seen him as a friend. However, after another few drinks at my home, we ended up having sex. the thing is that I don't actually find him attractive when I'm sober and honestly I feel really bad about having had sex with him. It was completely out of character for me. I was just wondering if anyone had advice for getting rid of the feelings of shame, guilt, and repulsion I now feel. I can't think of him without wanting to be sick. He is a really nice person and I want to end this in the least cruel way possible. please give me some advice thanks. also is this normal?