For those women not getting why, my "scare" about menopause is this one: when she declares "I'm not interested in sex anymore" (due to hormones change or whatever else).

Trust me, that would scare the vast majority of men (not just because we like sex A LOT, but because we usually need sex and physical touch to feel loved).