OP - this is MN. You are not going to get a balanced view about SAHMs on here. Just know that.
There are women drawn to these threads who, to put it bluntly, know they are not cut out to be SAHMs themselves, so they find the fact that other women are, and that some families highly value the SAHM role, to be bewildering and even threatening.
There are even more women who can't afford to SAH even if they wanted to. So this sort of thread is always going to provoke a degree of angst and jealousy from some (well, quite a lot, to be fair).
There are women on these threads whose husbands won't even have shared finances with them. No wonder they can't comprehend the concept of a SAHM!
There are women who have been brainwashed into thinking you can't be "equal" in a marriage if you don't both work. In other words, they have come to equate "value" with income. Again, that is about them, not you.
There are women in here who have been with horrendous men and who have been left very bitter following divorce. Their sentiments are understandable but, equally, not everything needs to be viewed through a doomsday lens - nor does everything need to be a race to the bottom either.
Anyway, amid all the projection (which is 95% of these threads), there may be the odd poster who is genuinely not projecting and has an actual salient point - ie. think about the impact on your pension; ease of getting back into the workplace etc.This however, is not rocket science and it sounds as if you are eminently capable of considering these issues as they pertain to you. All the anecdotes about so-and-so's cousin's neighbour who struggled to get back after x years is neither here nor there. They are not in your role or industry!
In the real non-MN world, of course millions of women take a few years out to care for their children pre-school - to great success and to the benefit of the whole family. It's hardly compulsory to put your kids in daycare, or with other people. Not should it ever be.
I agree your DH needs to be on board but, the point is, it doesn't matter what anyone else thinks. It's your family. Of course your feelings count. Talk to your DH. Point out the benefits of your child having his / her mum around for a few more years. It's not as if you're saying you will never work again!
You will work out what is best for your family in YOUR circumstances. But no, in principle, of course YANBU to want to be with your own child!