Pissed of a Scorpio - why is he so hot and cold?!

Sorry but this might get long. There is background. I have known my scorpio for about 3 years. The relationship part just started last month. It has been intense and wearing already. Heres the background:

I met him through his best friend, who is also one of my good friends. I have known the friend for 20+ years, and friends with benefits is an arrangement we have fallen into and out of over the years. Besides that, it has always been strictly friends. The friend and I have not been messing around for a while now. And i think my scorpio noticed that, and thats why he finally reached out to me. Over the course of the 3 years since I met my scorpio at our friends house, I see him about weekly. I’ve been “one of the guys” and so I know about his love life, etc. he’s not a player. He’s not a sleep with all he girls type of guy. In fact, he’s the first to usually catch feelings with the girls he does mess with. But all of it is a rarity. He never made a move until last month. He texted me, confessed he has been into me for a really long time and went hard trying to get me. Our conversations flowed like water. The spark was just undeniable. I had never even looked at him in that way. So naturally, I took pause, as I was concerned it would change the dynamics of a place I spend a lot of time in (our mutual friends house). I took a few days to think about it, decided the spark was worth whatever might happen to the dynamics and then bam. He was suddenly stricken with guilt. I have to add, the mutual friend must have sensed something because he went back to trying to rekindle our previous affairs, which i have fully shot down. My scorpio pulled back and said as much as he wants to, he cannot do this to his friend. However he continues.

He has been hot and cold since. If we end up alone in the same space at out friends house, he grabs me to the side, tells me how he has done everything he could think of to get me out of his mind but that he can't. One day he is blowing my phone up telling me "this doesn't even feel like real life" and "sometimes when we talk I feel like i'm texting a bot specifically designed for me". How he is in so much like with me. And its not just on his side. I feel the same way. It ridiculously great and intense. Then the next day he is silent and brooding and telling me that he can't continue this because his friend would not approve. Also saying things like he knows I have feelings for our mutual friend. The only alone time we have spent together is private moments we have had at our friends house, but it happens everytime we see each other there. He has on a few occasions invited me over to his place, but only when he knows I can't actually come. Well on Saturday night we were all at our friends house and he takes me aside and asks me if I want to spend the next day at his house. I say yes. Next morning, he started to back peddle. Saying he isn't sure, and that it won't be until later, etc. This is where I fuck up. I told him I'm done with the wishy washy, back and forth. I told him I'd be there at 6, and he could tell me no to my face. I show up. He lets me in. Acts slightly miffed about me just showing up. We have a great night, we get hot and heavy as usual, its like magic. Next day hes pissed i overstepped a boundary and is icing me out. Told me we need to chill on this for a minute. When I asked for clarification, he got real pissy.

Add to that tonight is a night we all usually go to our friends house. He knows I'm going to be there, as I am almost every Tuesday. And he's going. What do i do?? Did i ruin everything?? Should i go tonight? I have never dealt with a more hot and cold person. I'm a leo. Heart on my sleeve. I don't make bold statements then turn back on them. AHHHHHHHHHHH. Any advise would be greatly appreciated 🙂