With midlife women more visible than ever, the benefits of ‘active ageing’ are many and varied - from bone density and mental clarity, to wild affairs with younger men