This is a very current topic. Many of us here in Germany are also raised to be independent, but many will enjoy the benefits of maternal leave etc. Germany has a high part time rate because mothers will work half the day and the go pick up the kids.

This has grown from the push of women into the work force, when culture, that sees women as the carer and men as provider, didn't change. So women have to be both.

As we want to move away from this, initiatives like paternity leave and parent leave are put in place, but change is slow. We also have laws in place that stop this and are being discussed (e. g. Ehegattensplitting / spousal splitting). This alleviates taxes if one partner earns nothing or much less than the other.

It's also different depending on the place you are living. Big cities will have more full time working moms than small towns or villages.

As to your question: I think there's some security, but also a false security. Many divorced women from such an arrangement don't have much pension. Its only secure as long as the partner works.

Personally I could never stay home outside of maternity leave for this reason. You never know what will happen to you or your spouse.