i love this man. I am hoping maybe he realises he has caused so much pain over nothing and that he has really upset his young children seeing him like this. I hope he seeks help or his parents get him help and he can learn to control his temper and be the lovely man I love and know and not have anymore of these break downs. I also know that this may not happen as most abusers blame rather than feel guilt etc.
He won't. There is no 'may not happen' Op, he will not change. If he cared enough to change, if there was good deep inside him that he could find to help him change, he'd have changed last time, or the time before.
You need to accept that, Op, for the good of your children if not yourself. The loving, happy relationship where he changes and everything is fine exists only in your head. It does not, and will not, exist in reality, because he is an abuser and will not suddenly see the light. They never do, and he is not different to the rest of them just because he is yours.
Good people do not get so angry that they repeatedly see red and physically abuse their partners, hold them by the throat (to be clear, as a pp said, men grabbing throats and throttling is a significant escalation and the most common indicator a man will go on to murder his partner - this is very, very real), scream abuse at them and their family, and behave like brutes.
He does not want to change because he has you exactly where he wants you. So in love with him that you will stay and he can do whatever the hell he wants, including controlling you, your mum, and your children, by fear. You've shown him threats to leave mean nothing, so what incentive is there for him to change his ways now? What exactly do you think the trigger will be for the lightbulb to go off in his head and make him realise none of this is OK?
if he ever does anything like this again it’s over for my kids sake, although I know I’ve said this last time he verbally abused me and my mum.
And then you'll say it the next time. And the time after that. Then the time after that. And it will keep going on and escalating and becoming more and more normalised to you and your children until, maybe, eventually, you do leave, but by that time, your children will have been living in a home with an abuser, watching him abuse you and their grandmother, being scared and confused and growing up knowing that you can't defend them from it, and either suffering abuse from him themselves or feeling like they need to become your protectors and putting themselves at risk to defend you. None of that is good for them and only you can change it, because he will not.
I'm not saying this to be cruel, Op but you need to open your eyes to the damage this is doing to them already. He is not a 'good dad'. Good dads don't terrify their children or abuse them and their mother.
I don't doubt that you love him at all. It's ok to love him and to grieve for the relationship. No one thinks you're stupid, or weak. You're a victim of abuse, and leaving a relationship like this is not easy.
You have been given so many genuinely incredible recommendations above that women in your position have used to finally free themselves - you are not alone in this. But if you stay, you are knowingly putting your children at risk from him. You are making a conscious choice to allow him to abuse you, and them (because screaming and swearing in front of them is abuse even if not directed at them) 'just one more time', because you think you can change him, even though there hasn't been any indication he will, or even wants to, change.
How could that possibly be worth the risk? Their safety and protection from trauma comes above your desire for a family unit, even if you want that unit for them. Would you trade their safety for anything else? Of course not. Only you can decide when enough is enough, and there should only be one answer.
Please, Op, for your sake theirs, please leave him.