So, a normal alcohol fueled night.
But absent from your posting is any mention about what you want and are ok with. You need to do what you want.
But given what you said, i think his initial reaction was that he might have said something during the course of the night that he might be regretting. Pledges of undying love, or wanting to spend more time, or just liking the way you act in the sack. So he had to see what you remember. You didn't call him out on anything, so he is relieved.
If you want to see him again, you need to reach out to him in some way.
Putting having sex back in the bottle will be very difficult if you regret that and agree to meet him again for anything. But if you enjoyed it, and either don't mind or want to screw him again, then find out what he is interested in, and set it up. Be it a real date, a casual date, or a hookup. But the ball is yours. Contact him and get the ball in his court.