He’s way less attractive than his photos... but our connection is insane. What should I do?

I am so torn right now. I admit I am a bit of a "looks" person when I date, so this is really messing with my head. I matched with this guy on SparkRizz about a month ago and in his photos, he was a 10/10. We talked every day and he seemed so cool, so we finally met up for coffee last weekend. But as soon as he walked in, I was so let down. He is just not as handsome as his pictures and he looks way older in person. I just did not feel that physical spark at all when I first saw him.

The problem is, the actual date was one of the best I have had in a long time. He is a total gentleman and he really listens to me. He even got me to talk about my own goals and ideas, and I felt so comfortable around him. I am stuck because the only reason I even swiped right and started talking to him was because of his looks in those photos. It feels like a bait and switch, but we click so well. Should I give him another chance because our vibe is so rare, or is the lack of attraction a dealbreaker?