You're young, going by your profile. I'm guessing your chilsren are still quite young too.
You'll change you tune once your husband does cheat, or you get divorced, or you cheat because you got bored, or you start feeling like a disrespected maid as the kids get older. Or any of the other things that can go away with being a SAHM. Then, kind of like how conservative women are wailing that they didn't know they'd be required to die too by abortion bans (I didn't know the leopard would eat my face), it'll be "where did it all go wrong?"
I grew up in a deeply conservative area with women like yourself always going on and on about family values and home and hearth and the joys of motherhood. After a while it's like, who are you trying to convince?
You want to be a SAHM, go for it. Pointing out the pitfalls of that chlice is not shaming that choice. Any major life choice has potential pitfalls.
The point is to make an informed choice based on all the facts and to have a reasonable out if things go sideways.
That's just good sense. That's not oppression.
Hope you enjoy your life with that choice and that it does, in fact, work out for you. It doesn't for a lot of women.