OP none of this is circumstantial.
It's not because you're SAHP.
It's not because he's so amazingly busy or tired.
It's not because he's lazy, even.
It's because he isn't the slightest bit interested in his children as people. He doesn't want to spend time with them. He doesn't like them (and by that I don't mean he DISlikes them, I mean he doesn't actively like them - want to be with them, want to talk to them, want to hear what they think and have a laugh with them). He has never, ever, made time for them or shown them in any way that they are important to him and he is there for them and cares for them.
Even the tiny amount of time he 'parents' - he takes them to his mother and does nothing directly with them in a different house.
He does not give one tiny shit about them. And they are now beginning to see that very clearly.
What on earth is surprising about the fact that they in return don't love him, don't like him, and don't respect him?
Does it not occur to you that they see other dads in action, the dads of their friends, dads on tv, they see other examples of family relationships - and they compare that to him and they have nothing but contempt. Rightly so. He's an appalling father in every way.
The fact that he dares to get angry at your dd, that he reacts the way he does - omg, his feet wouldn't touch the floor in this house - he would have a few hard home truths aimed straight at his nasty little ass quick smart. He wants to be told that he is loved? Then earn it. Inspire it. How sickening - and so, so THICK - to try and bully a declaration of love out of his daughter. Yep. That's really going to help, isn't it? Make her actively hate you rather than just dislike you!
I can't see that he's any better as a husband - he can't be - to be so selfish, awful, self -obsessed... he can't be a rewarding person to live with, he can't be a support or a pleasure to have as a life partner. Do you want to stay? Your children would probably be better off with the honesty of a split, because he does not value the family except as a 'thing' the successful man has. The people in the family don't really exist for him.
Next time he shows his absolutely inexcusable 'anger' - do something to stick up for your children and tell him that he is reaping EXACTLY what he has sown and if he wants to turn it around, it is entirely on him to change his behaviour and try and build a relationship with them. Before it is too late.