Another male perspective:
I am in my early sixties, and my partner is ten years younger. She is just post-menopause. We have three children, the last of whom is about to go off to university later this year. My partner's menopause released us both from the tyranny of a week of bleeding every month and the PMT that we both had to endure. We both had a very positive attitude towards her menopause and the changes it would bring to our lives.
We have always had an active, interesting, and evolving sex life. We are hugely looking forward to having the home to ourselves and the opportunities this will give us to spontaneously express our sexual desires. We are both fairly active, healthy, and fit. We try not to become old mentally by taking ourselves on trips to other countries.
I am recently retired and my partner is still working, and probably will for another eight years, or so. We are very happy with who we are, where we are in our lives, and with each other.
I am able to give another perspective though. Before I met my partner I had a wonderful relationship with a FWB and we kept in touch as friends for a couple of years after our sexual relationship ceased. She was a woman with an incredible sex drive: for her, sex was the defining thing in her life and she loved every aspect of it. When we parted she got married to a man who was the safe, secure, and sensible choice. She curbed her sexuality to a huge extent as she realised that it was not a big deal for her new husband. She loved him and he was a really great guy, but there was not the sexual chemistry that we had together. Her sex life was very much vanilla and infrequent, but she still enjoyed what she was getting. She satisfied herself with regular masturbation. Health problems came along that necessitated a full hysterectomy; this plunged her into the menopause. Overnight she went from a highly-sexed woman into a completely sexless being with none of the defining desires she used to have. She had no interest whatsoever in even satisfying her husband's basic needs for the occasional orgasm, despite still loving him very much.
We are no longer in touch, but I do wonder where she is now. Her story contrasts with my partner's experience of the menopause, and it turned her life upside down in a way that was not positive.
It is very much the luck of the draw as to whether we grow together, or part, whether or not we experience a positive menopause, what cards we are dealt in terms of health, prosperity, etc. I know that we are lucky, but am also aware that to a large extent we make our own luck. Our relationship is something we have worked hard at and we are fortunate enough to reap the benefits - not everybody is so well-placed in life.