Well, my answer to the question you've posed is, who cares? Who wants to, or is able to, live their lives according to others' expectations? Which others? You'd be torn in every direction!
What matters is what matters to you and your DH. What is possible, what is necessary, what are your values, your preferences and how do those fit your circumstances. No-one else can tell you what those ought to be, or what is possible, or preferable, for you.
What you actually seem to be saying is that your family can get by on one income. Your DH believes having a SAHP is desirable and that it should be you. He sees you trying to work, even as part-time and flexibly as is possible - in a way that could be made completely compatible with supporting school-age DCs - as a waste of time, as the money isn't needed and he would prefer you to focus all your time and effort on the DCs (and him?).
Whereas, you want some financial independence and to keep your CV alive, with the idea at the back of your mind that you would like to know you could support yourself, should that ever become necessary.
There is an unsaid inference that your DH might not want you to become capable of economic independence.
My view, even if that inference is incorrect, is that it is a very good idea to keep your CV alive and maintain the potential for economic independence. If you can earn some extra money flexibly, while not compromising your ability to get involved with school things to the level you see as desirable - then that's a total win-win.
But that has nothing to do with what anybody else 'expects' - other than your DH himself.