Curious if I overreacted

I've been dating a Cancer Sun/Leo Moon/Cancer Venus guy for a little over a month. He was saying all these things about how he prayed to meet someone he matched with and felt they were answered, that he's happy when he's with me, is falling in love with me, wants me to meet his family and meet mine, talked about moving in together, said I'd be a good mom/wife, he sees me being in his life a very long time, very consistent with his communication and overall it was going great. Then this week I asked if he was okay having dinner with my brother, he said sure. Then 2 days before says he thinks we should wait and asked what I thought about 'us' I said I feel good, I think we have a lot of potential together, he said good cause he felt the same but then asked if I felt if sometimes we were quiet. I asked him to explain and he really couldn't, then said sometimes it was like we were together but we weren't. He said he still wanted to meet my family but thought it was better to wait a few weeks, I said its fine and I didn't want him to feel pressured, we've only been dating a month and have plenty of time and still need to get to know each other.

He said he still wanted to spend the evening with me cause he missed me so we planned for him to come over. The day he was supposed to come he texts me asking if I would be mad if he said yes to working a PM shift cause someone called in, I said no it was okay things come up, then he goes on and on about how he'll try to leave as soon as he can, if its not busy he can leave, he'll keep me posted, etc etc. Goes back to how he misses me bla bla bla. Never heard from him for almost 5 hours. Me waiting around wondering if he was actually coming or not. At 10:30 I sent a message just saying not sure what happened, thought I would've heard from you by now and am going to bed.

I thought it was odd cause it wasn't like him at all, we met online and I decided to check and see if he's been active on his dating profile. When I looked it said he had logged in the night before. Anyway I got even more pissed and sent a message (impulsively I admit) saying he wasted my time and lied to me (HE is the one who brought up being exclusive and having zero desire to meet anyone else, yet he was on the dating site the night before we supposed to meet. So I asked if he was really working or did he have a date, and that I was hurt and thought he was a sincere person.

That was around 11....he texts me the next day at 3 and says he was disappointed cause he thought I trusted him, and that he got distracted at work and then tipsy afterwards and forgot to send me a text. And for the dating site he had logged in to deactivate it before they charged his account.

I told him I treat people how I want to be treated and I never would've gotten so distracted or drunk to the point I would forget to text him, especially knowing he was waiting to hear if I was coming over or not. He's not young, he's 41, I'm 31. So come on. I am hurt and sad cause I thought we had a good connection, but it just seems like a really lame excuse to not at least say hey, super busy so I don't think I can make it....thoughts on this? I'm Aqua Sun, Gemini Moon, Pisces Venus if it matters.

I had a few too many drinks and ended up sending a message that I was sorry and overreacted (after talking to my Scorpio friend who said she thought I may have just a 'tad bit') I told him if he wanted to try again I'd be happy to and if not I also understand. He messaged me back saying 'for sure we should meet again' and to plan a day next week. Then he called me later in the evening and we chatted for about 20 min, I said sorry again and he said he was sorry and that he should've sent me a message. So we'll see how that goes. I was in a relationship for 9 years with a Cancer and I broke up with him about 4 years back, I'm pretty sure he's a sociopath so I didn't want to make comparisons.

Someone above mentioned him testing me and possibly wanting reassuring, that thought never crossed my mind. I thought if anything he'd appreciate me not guilt tripping him but maybe I was wrong! We'll see how it goes.

Btw these are the rest of his placements if it helps give some better insight, I don't know his birth time unfortunately.

Sun - Cancer

Moon - Leo

Mercury - Gemini

Venus - Cancer

Mars - Leo

Jupiter - Taurus

Saturn - Leo