New Relationship I Probably Ruined

So, a little over a month ago, I met a really nice, sweet, great guy. Everything was going fine until last Wednesday. We had a big argument. The same day, something happened with his sister out of state. This has been really upsetting to him, quite understandably. Over this last weekend, he and I were okay again until Saturday night when he seemed a little off. I asked him what was going on. His mind kept changing from wanting to break up, to not knowing what he wanted, to asking for space. We decided to slow things down and go at our own pace. Of course, I agreed to give him the space he needs. That was going fine until yesterday and today when I likely screwed everything up. After he got out of work last night he sent me a text message asking how I was doing. I responded. I was at a bar to find out about a mutual friend. I only meant to find out about this friend, have one drink, and leave. I ended up not knowing how many drinks I had. Meanwhile, another guy who seems to be really attracted to me sat down next to me. This is a guy that was told by the guy I’m dating to leave me alone. He also told me to let him know if this other guy keeps doing it. So, I did last night. However, I ended up getting so drunk that my boyfriend had to come and pick me up because I couldn’t drive home. Idiot me, in a drunken mess, sent him like 10 text messages saying some pretty horrible things. I don’t really remember it. All I know is that I woke up this morning horrified that I had sent those messages. Anyway, he took me to get my car this morning. Then this afternoon, I sent him a very long message apologizing for my behavior last night. He asked for space, not to take care of his drunk girlfriend. I am worried I have ruined anything that could have been salvaged. We’re supposed to go out tomorrow early evening. So far, that hasn’t changed, but I won’t be at all surprised if it does. I know he is really struggling with the issue with his sister and I didn’t give him the space, so far, I promised I would. Is there any way to fix this at all? Is there any possibility of making things right? Or have I completely made an ass out of myself and ruined it entirely?