Feeling depressed and confused after hooking up - please help me out friends? - Beehaw

I was at a party where this very handsome guy kept making moves and initiating. It felt so nice to be chosen out of many people, and the chats were good rather than superficial small talk. After a while he asked “my place or yours?” No matter how much my mind is aware that I am not the type of person who can carelessly hook up and I get attached, my heart can’t say no in the moment. So we went to his and hooked up. We were also drunk which didn’t help. Full disclosure, he couldn’t get completely hard, and I wonder if it has to do with me but he said it’s probably because he’s drunk. We mutually did other intimate things too, and cuddled afterwards which got me - he was giving compliments and being sweet. Then it got weird. I couldn’t sleep and woke him up once after which he turned over and at one point said “get out”. He was in and out of sleep with eyes closed, but it was very clearly said. I accidentally left something small at his place and he added me on social media later on saying he found it. We sent a few flirty messages back and forth across a couple days and he recently asked about my weekend plans but is now ghosting me for the second time. I just feel old and stupid. I naively thought there could be something this time but they are all the same. I hate that I fell for it and couldn’t control myself. Did he already write me off as casual when he asked? Before that? Is it really not burning the bridge if I were to politely decline and say I wanted to get to know him better first? What should I do or say now? Another thing is we’re in an organization (not workplace) where word travels fast, and I asked when he was drunk to keep this between us. Should I have a real talk with him, over food or just a talk, in person or a phone call? I feel so lost. Please help me out, friends. Thank you!