A Great Connection, But No Future: Should I(28F) Let Go?

I(28F) have been in a relationship with a guy(26) for the past 5 months. We are in LDR. He's in Delhi and I am in Mumbai. We get along really well otherwise whenever we meet, no discomfort at any point. He doesn't want to eventually get married or have kids and I do. We have been discussing how this is going to be a problem for us, especially for me since I am older. I am also not a fan of the LDR point. Should I end it with him asap even though we have been getting along really well, emotionally and physically too.