LDR Not Likely, Feeling Very Stupid

Hi everyone. I need some advice on how to think and feel right now because I'm trying not to beat myself up about this, or feel hopeless. And I'd really like for this to work out.I just had a great date with a boy last night. Everything went right. We met for food. We like each other. We went back to his dorm to watch Drag Race. I've never felt this much chemistry. But after we've been watching and warming up to each other for quite a while, he stops and explains that he's graduating next week and doesn't' think he can do a long distance relationship.I knew he was graduating next week. And I knew he wasn't that close. What I didn't know was that he lives five hours away from his college. And I myself live one hour away from his college. So, we're six hours apart. And there's a possibility he may move out of state. (Actually, after doing some quick digging, I live only 4 hours from his hometown)I felt betrayed because everything was going so well from the very beginning. I asked him, "Then, why did you say yes when I asked you out?", he responded with, "I don't know. I thought I was just meeting new people. I didn't think it would go this well. I would have made a move, but when you put your arm around me, I realized I should stop this because it hit me that I'm moving back soon."We talked about it for over an hour while showing affection (no kissing). Because there's real potential here. And that's what's making me feel so frustrated, sad, and stupid. Because additionally, I used to go to this college. I saw this boy, once, over a year ago. In my mind, I could have talked to him then and could of had all this time to get to know him. But I didn't. And now he's moving. He wants to stay friends and see what happens from there, but I can't rely on that and hope that somehow it'll magically happen. But I also can't just talk to him as friends without the hope of something more.This boy is amazing. He had a full ride to his college, he's probably graduating with a 4.0, he plays games while managing a life, he's hella cute, he shows affection, he messaged me something meaningful on grindr, and he's just awkward and shy enough. He's not a snob. I can't believe that I'm going to find that again. That mix of traits? No way.So I don't know what to do. We texted about it a little some more and he agrees there's chemistry. He just doesn't think he can handle that. And I respect that. But my mind sees a way of making it work and I can't get past it. He's thinking about it right now and I'm trying to give him that space.So in my mind, I WANT to try and plan a way for this to work. I see a problem and I think it can be fixed. He doesn't think he'll be able to find someone because he doesn't go out that often. I've done ldr before. Not that far away, but far enough that I didn't see my bf for two months (And learning it's 4 hours away, not 6, is a huge difference). I know I can do this because potential relationships are things I go into with clear decision making; I want it enough to work for it. But he doesn't think he can handle it, and I have to give him room to decide.Help Reddit. I don't know what to do. I want to give him the time to think it over. Should I meet with him in-person again to talk about it? Should I just not try? I see a lot of potential and he does too. I want the opportunity to call him my boyfriend and get to know him more- and I think that can be done ldr. I just wish we had more time to get to know each other before he had to leave so quickly.EDIT: It turns out his Hometown is only 4 hours away, not 6; removed a paragraph complaining about gay dating; added more questions I've thought of after initially posting.