Aqua ex slipped through my fingers

I posted in the aqua forum but thought I'd post here too

https://www.dxpnet.com/opinion/aquarius/apologising-to-aqua-ex-4988269/
Posted here before about how I was starting to reconnect with my aqua ex.

We had been talking quite a lot, and we decided to meet. I thought it was a good time, because I felt like I was in a good place, didn't think anything emotional would happen. That we could be relaxed and enjoy ourselves. I wanted to bring up the past briefly to apologise (see above topic) but I thought I'd wait to see if he brought it up at all

When we met it was amazing, he kept bringing up the good times, saying he had just come out of a rel which was rly messed up and it brought out the worse in him and that I brought out the best

And he kept bringing up things that i thought he had completely forgotten about, or not cared about.

After some time he kissed me and we had sex and he told me he realised recently how he made mistakes with me, and wasnt open enough which he knew made me insecure etc

So i then apologised to him for my mistakes

So i obviously thought the connection was still there or he liked me still

The next day we went out drinking but then disaster struck
We got quite drunk and i became rly quiet because i felt like he was being more distant and not as affectionate as the day before

He asked what was wrong and told me to talk to him, so i became rly emotional and told him my feelings were resurfacing and asked him what he felt for me

Then i started asking questions about his recent ex, whether he felt the same for her that he used to for me

He always always always used to say what we had was rly rare and special,, but he wasnt telling me it anymore. And i wanted to know if he found that with anyone else cos i havent, I wanted to know what we had was real.. and if I was justified in still having feelings for him after all these years..

He freaked out by my freak out.... Understandably, i was very emotional, saying crazy things... Crying....

Next day he told me he cant be normal with me after what happened and now is so cold with me

I dont understand. I told him i still had feelings why he so scared? He had sex with me the night before, but he cant handle me telling him i like him?

Things are in an awful state, and just done a complete 180 in 24 hours. We were getting on incredibly, better than ever... And then this happened

How can i fix this? He said he wants to be left alone, but im sc

.....but im scared ive just lost him forever now. I know I scared him and should just give him space.. but I'm afraid that that was our last chance and he will never want to see me again 😢