The is loads of good advice on here but a bit of not so good advice. You must remain the better person and however much you want to, don't vandalise any of his belongings. You have to be a decent human being for your son, because as far as your husband is concerned that ship has sailed.
Get him out of your home quickly with only things that are 100% his. Clothes, toiletries etc. but nothing else. To allow things to drag on will only make the trauma worse. It's a shitty situation of his making so he doesn't get to dictate terms.
I find it hard to believe that a 40 something "grown" man can behave like this. It sounds like the behaviour of a 14 year old. Do adults actually watch/do tictok? In a month or two, when the gloss has worn off, and he tries to come crawling back to you, remember how you feel now. Write down your feelings, the hurt and betrayal and the effect it has on your son. If he can do this once, don't give him the opportunity to do it again.
You are obviously a strong woman and have all the advantages in this situation so don't give him an inch and if he starts crying again just leave the room. You've already wasted 10 years of your life on this loser so don't waste any sympathy now.
Look for the positives to keep you going, you have your son who is your number one priority and once your initial anger wears off and you start to feel down don't show any weakness. All the sorrys in the world won't make up for how you feel right now.
For your son's sake your husband has to leave immediately so there is time for him to get used to his new way of life before changing schools. When I was at secondary school my Dad's job moved him about 300 miles away, coincidentally quite close to where his Mum lived, but because he didn't want to uproot the family he commuted and stayed with her during the week and came home on Friday afternoons. This lasted for a couple of years till the job moved him back again and he could travel from home. My Dad had no choice, but made the best of it, your husband has made this happen so when it all goes tits up, and it will, he will only have himself to blame.