I've known a guy for well over 10 years, and I've never been interested in him beacause he's always seemed a bit.. like a chauvinistic pig.. However! Two weekends ago he was at my place for a party, and last night he asked if we should drink toghether. I naturally assumed it would be a party, but when I got there it was just the two of us, which surprised me beacuase we've never hung out just the two of us in over a decade. 

He explained it and said he thoight we "had a new kind of connection last weekend" and I agreed even though I didn't remember anything special from that night.. 

Anywho, we drank and talked all night . I saw an entierly new side of him that night. He was compassionate and listening to me, told me stuff I had never guessed about him and so on..  and.... we ended up in bed togheter (nothing unusual for me, I've slept with most of my friends)

The problem: He (If I understood correctly) is now interested in a relationship with me, or at least dating.. 

What do I do? I'm not in love with him. But, he has a stable life, a job and is moderatley attractive. 

Should I try dating him? Or am I just setting myself up for faliure?   
I don't know if I'm in the right mindset to date, but I don't want to miss an opportunity at love..