So he was sober and had sex with you for hours whilst you were unconscious with drink, but it wasn't rape? And he truly believes that you being so comatose that he had to carry you into the house and continued to be unaware of what was going on was consent? Really?
This shocks, disgusts and worries me: what sort of man could find you a turn-on in that state? What sort of man would find that scenario a turn on? What sort of man truly believes that an unconscious partner is 'up for it'?
This story rings so many warning bells: it's not both of you being tipsy and him making a bad judgement call, this is him taking hours to do what he likes to you whilst you are unaware of what he's doing and unable to stop him or participate. If you read this story in the papers about a stranger doing this to a woman he'd picked up, what would you think? You would be sickened and think some pretty harsh things about the guy. Just because you were dating does not make it somehow okay. Legally, what he did was rape.
I hate to make things worse, but are you sure that was the one and only time? Can you be sure he's never done it to anyone else? Can you be sure he hasn't done it to you since (ie if you were deeply asleep)? And, sorry to ask this, but can you be sure he didn't film it or anything?
He sounds like a freak. Being sexually insensitive is something like wanting a shag when your girlfriend/wife has a cold (and then doing nothing when rebuffed). Not treating her like a blow-up doll. This is not normal behaviour. It's not just 'one mistake'. I dunno where you should go from here (but if it was me, it would be out of there, ASAP), but I think counselling has to be part of it. Sorry if I've come across as harsh, but you need a wake-up call. What this guy did to you was wrong, wrong, wrong.