He’s right, he has made a huge mistake. You only needed a tiny bit of love / attention / affection from him in return for the huge amount you were giving him. And he couldn’t even manage that.
Now he knows he miscalculated. He wants you back and he will give you lots of cheap words for a few weeks to get you back again. Anyone can send texts / videos saying how great you are - he can easily do that while enjoying all the comforts of married life.
He will say that he wishes it was different , while ignoring the fact that it’s in his power and control to make things different. He’s not a passive victim of circumstances here - he’s the one in control of his own life.
Yes you are amazing. The reason he’s not left his wife for you is not because your amazingness is insufficient . It’s because he’s a cake eater . He believes that he’s entitled to married life plus another woman on the side.
One woman at home to run the house, raise his kids, do all the wifework and emotional labour at home ( and perhaps a romantic and sexual relationship too - who knows ? ) .
And another women for all the fun , sex and romance, while his wife stays at home and looks after his kids.
You are not the problem, he is. Stay strong.
Remember , if everything he says is true and you are meant to be together, he will move out , divorce his wife and come back to you as a truly single man. Then if you still want him you can start afresh and see if he is willing to do 50% of the effort in a relationship with you.
You will also see if he’s the amazing father he says he is because he will be doing 50% of the care and parenting of his children.
Id advise you not to put your life on hold waiting for him.