Hi @penelopepinkbott , judging by a conversation I had the other night with DP, you could be her. (Although I'll presume you're not.)
She like you is around 40, and has put on quite a bit of weight over the last couple of years (largely due to side effects of medication she's had to start taking).
The honest answer is that yes I'm less attracted to her at the moment, but it's not due to the weight, at least not directly.
Purely based on appearance, I fancy her just as much as I always have done. A few more curves and a bit of extra squishyness have not changed things at all. I'm sure there probably is a point at which that changes, but not right now.
What has lessened my attraction is the fact that her weight has caused her self confidence to take a hit. I like the lights on during sex, I want to see my partner bouncing around of top of me naked and being entirely unbothered about it. People who are comfortable in their own skin are hotter.
What I'm trying to say is not to care about your own weight too much, because people who are comfortable with their bodies are more attractive. And yes, I know it's easier said than done.
Now the conversation with DP went down like a lead balloon, so I imagine this will to, so apologies if I offended anyone.