Okay, thanks for the clarification here OP.
Actually, I think this is a little more nuanced than what I first thought. It depends partly on his reasons for him disagreeing with your work ambitions.
For example, if he thought what you are doing is morally wrong, then I wouldn't expect him to help you. For example, (and dear lord I don't think this is the case!!) if you were planning to screw someone over to give yourself a foot up, then he might think that's morally wrong, and therefore not support you with it. And that I could understand if you were listening to him, but wanting to do it anyway.
In a less extreme example, say he was worried that this new work thing would mean you were away from home much more - he might have concerns about that too which you two would need to work out before he would support you. For example - in this circumstance he might be worried the children would miss you too much, or you would miss out on key moments in their lives. Or that the added stress would be bad for the family. Those would be genuine concerns that you guys would need to reach an agreement on before you could expect his support.
If it is a matter of you saying "I want this from work", him replying "I don't agree because of X reasons" then you saying "ok fine but support me anyway" then you aren't taking any of his concerns into account.
But to be honest OP, whilst I understand your question better now, there is going to be so much that depends on context that it's hard to say.