alir1, I am glad that your anger is surfacing. When I read through your story, several things didn’t add up to me. I don’t consider him to be just a well-meaning fellow who got in over his head. The entire way he handled this makes him suspect.
In my opinion, this is an immature 52 year old who enjoyed the ego-boost of your adoration and the thrill of the chase, until he didn’t. He felt entitled to throw out empty words to pull you in and push you out. He is a manipulator who is structuring his exit as a noble sacrifice.
You had concerns and he soothed you:
I asked him if my kids would be a problem. He said no everyone has kids and if they didn’t I probably wouldn’t have anything in common with them.
I told him that I didn’t want him to meet them if he wasn’t in it for the long haul. He said I know what I’m getting into.
All was perfect, but he called it off when you had a sad face. Did you notice that he exaggerated your reaction about the trip from a bit sad (your words) to so upset (his words). He was heartbroken to see you like that. He grabbed your sad expression, completely over-dramatized it, deflected the blame to you, and ran with his ‘You deserve better, I must let you go’ exit strategy.
Other red flags are his adding his friend and your children to the equation. He is throwing in everything but the kitchen sink!
alir, he is gaslighting you. The thrill has waned and he wants his single life again. No matter how he spins it, he is not breaking up for your benefit.
You're right...he doesn’t deserve your friendship. And I wouldn’t allow him to “text the occasional small talk.” I would go NC. He can take his love-bombing, future-faking self elsewhere.