He wants us to stay exactly as we are - my questions to the world at large really are: is that what lots of people do/is it actually an acceptable trade off? Does wild and lasting romance exist for everyone else/am I missing out on my Big Love? Is this as good as it gets? Etc.
What you are now doing is lowering your standards and expectations so that he fits into them and you can tell yourself it’s ok.
As a married woman 31 years in, with loads of ups and downs in these years, I can tell you that no, romance doesn’t always last and your partner won’t always look like the hot 20 something that they were. Love takes different forms. Everyone’s take on love is different, everyone has different things they’d put up with.
DH and I aren’t jumping each others bones much anymore, but neither of us care. DH and I are still really intimate in loads of other ways. I’ve put up with a lot of crap from my DH. Not affairs or anything, just thoughtlessness and he’s a bit selfish and lacking in self awareness. However, the big thing I will never compromise on, the hill that I’d die on is my own self respect and dignity. Go after that and I’ll lose my shit big time.
Your DP is doing just this. He’s taken a sledgehammer at the large part of your esteem that is made up of how you view yourself in terms of looks and desirability. What he’s basically saying to you is “On paper, you are brilliant. We get on great, I like your family, I’m enjoying the practical aspects of our relationship and I’m very comfortable in this set up. I don’t really fancy you though. I wish I did, but I just don’t”.
I think there’s an element of misogyny here too. He’s perhaps got an idea of what a perfect woman should look like and he’s deluded. He thinks he’s settled.
If someone told me I wasn’t their type or didn’t fancy me a few dates in, that’s one thing. To keep it to yourself and let things develop to living together is downright underhand.
After 31 years, my DH may not think I’m the hottie I was at 24, and he doesn’t squeeze my arse when I walk past but yesterday I got told I was gorgeous and he makes me feel good about myself.
It’s very clear that he has affected you quite badly. Personally I’d be making plans to leave him high and dry, and I’d also be ripping a few strips off him back to bring him back to the reality that he’s not a 25 year old Paul Newman lookalike and that you can do better than him, but he can’t do better than you.