Screwed up a possible lovely relationship after been clingy

I wonder if still there is a chance to become attractive for a guy after we had a hook up on the 2nd date… So… here is the story in short: we met via tinder. After texting for 1 month, we met for first time in a cafeteria. It was nice, we laughed a lot and I felt the click after eyes contact. Then we kept texting for 3 months more. We live in different cities (3 h away) but I go frequently to the beach (1 h away from his place) So, for new year I went to my apartment at the beach, and I invited him on a weekend!! He said okay but I am affraid he didnt actually, want to go, because that would mean physical contact. He went to me any way. He told me .. “so… we are FWB?” I said “i dont know what to say” .. and We had a hook up anyway… which was not natural but kind of forced… as he stayed there and we spent the weekend together.. there were no feelings at all… I just like him.. and he tried to make eze contact with me, but there was not the click any more.. I was sad because my selfsteem was down already (as he texted me only each 4 or 5 days always… so, I kept feeling insure all the time until we met) He left my place and texted me the same day and then the next day.. I asked him to come again on the next weekend.. he said he would tried… but then he said he “got covid” … that was my last weekend there on the beach so I expressed my feelings for him.. I told him I like him and that I didnt know what to say about FWB because I actually want stability for my life (HUGE MISTAKE!) and I told him that for me the distance is not a problem.. that I can come to the beach frequently as I work remotely. He replied that he doesnt know yet what he wants and he prefers to be just friends … I replied “alright :) ” and he replied ” :) ” and from then we havent texted for already 1 month…. I dont know what to do… I feel bad because I initiate the physical contact… He was not looking for sex… I was looking for getting closer to him… but in the wrong way… after feeling so bad I learned that I made a huge mistake by inviting him to stay and sleep together.. we felt like strangers throwing one to anothers body. I feel guilty and shamed. I dont know if text him like pretending nothing has happened. I would like to keep in contact and be attractive for him again… he was attracted by me.. but he hasnt decided to commit or even worse, to move to my city. What to do?? I know he wanted to connect emotionally but I didnt have patience and showed desesperated and anxious