You can interpret this a million different ways, he was drunk you brought him home and maybe he sobered up a bit and decided against it. Not a bad sign that he friended you after but maybe he knows he has an easy in based on the first night of meeting him and you brought him home. Let's not jump to conclusions that he's now all about relationships and dating here.
You lost me at the part where you said you want friends or relationship after bringing the guy home for a one nighter. And you don't know him that well yet.