For me in retirement, my house is a place to live, which we are doing up with no expectation of selling on at a profit. We only need pay the bills and the world stays outside the front door unless invited in. It is a small haven.
I'm not in my "forever home" yet. My house is a place to live in and raise my family, but it's totally inappropriate for retirement (if only because its a 3-storey town house and my knees won't tolerate that when I retire) and I'd guess I'm not a minority in that either. When raising families, people prioritise location near schools, public transport links, gardens for the kids to play in, driveway space for multiple cars (with two working, commuting parents). I won't need any of that when I retire