I'm almost two years on. Whether I can see an end to it all depends on what day you ask me. I would say that I often feel proud of what I've achieved, and thankful that I am free of a deceitful man.
My DD struggled with it all, similar to how you describe your DS. She was very hurt by his betrayal and devastated by the tearing apart of the family unit. She self harmed and received counselling. My son was on antidepressants.
I don't know why unfaithful spouses can't see the inevitable end result of their affair when they're in the midst of that exciting affair fog, and either leave the marriage honourably or think about what they stand to lose and pull back.
But the counselling, and talking between ourselves once it happened, revealed that a lot of their worries were for and about me. In their own way, they were trying to be strong and avoid talking about it for my benefit in case it upset me. They were worried about hurting me by still loving their dad, They were worried about my future, and practical things that they felt selfish for thinking about. They were angry that I was pretending to be ok when they knew I couldn't be ok, even though they understood I was doing it for their benefit.
We're in a much healthier place now. We talk openly, all of us. I can come home from work and say that I'm feeling a bit flat and they put the kettle on and we watch a movie. They talk to me or phone me if something has upset them. I still put a broadly positive spin on things, but I'm not putting on an act that they could see right through anyway.
I'm sorry you're going through all of this too. Such selfish men, feeling that their right to happiness trumps everyone else's. My ex said he felt he deserved his affair because 'you only get one life'. Yes, and so do I, and so do your children, and so does everyone else hurt by your actions.
Hang on in there op. You're grieving a man who never existed. Be thankful your marriage produced lovely children, be thankful he's someone else's problem now and start taking small steps towards building a life for yourself.