Does he just want a drunken fling? Should I give him a chance?

Alcohol gets the best of us. Wait for the next morning then reply. Ask him if he wants to go for coffee or something to get rid of the hangover. If he turns you down, then yeah.. he was just looking for a druken fling but if not then there could be something in the future. If he didnt want to go any farther than making out of the futon then he seems like a half decent guy.