How to confront or deal with complicated FWB situation?

CONTEXT: I’m in a LDR FWB situation with a friend that I developed complicated and deep feelings for. When I first confessed, he rejected me. Things got a bit more complicated when, during a weekend getaway, he drunkenly told me he wished we could be together and also talked about future plans of us growing old together. A lot of lovey-dovey shit basically. Apparently, he got too drunk to remember anything, so nothing ever came out of that until I got drunk and spilled my guts AGAIN a few weeks after I got back home from that trip. The next day, we had a conversation about it and he mentioned while he would give me a chance and try things out if i were to move closer, he doesn’t have feelings for me now and is also completely content being alone and has no interest in changing that anytime soon. He also said he had been thinking about the idea of us “on and off” for months. He did also clarify that he while he doesn’t reciprocate my feelings, it has nothing to do with me and more to do with the fact that that he just won’t allow himself to commit to a LDR.

Now, I feel like I am stuck in this loop in which he reels me in, gives me his “all” and then suddenly pulls back and acts cold, distant. It makes me feel like I did or said something wrong. I wish I could talk to him about it but any time I bring up something that he did that hurt my feelings, he shuts me out and ignores me. I want to understand his behavior and why he acts like that. I’ve been an emotional wreck ever since I developed feelings for him especially after I confessed and got rejected, and then even moreso now that the possibility of us is in the air (*according to him*).

What can I do to better my mindset about this situation and how should I navigate myself?