Barring catastrophe, it will almost certainly go up if your time horizon is longer than 10 years. If you are in a big city, the populations are growing faster than new housing is being built. On top of that, there is no space to build many new single family homes so those will go up even more if you own one instead of a condo or townhouse.
I bought my first house at the peak of the last bubble. Ten years later I sold it for more than I paid for it, and those last few years my mortgage was a fair bit lower than rents for a comparable place.
Most people simply haven't wrapped their head around exponential growth. Our economy grows exponentially, and our population has historically (there are signs this might be changing). Unfortunately, I think our environment can't sustain that, but as long as it does, things will go up if your time horizon is long enough.
Edit: also, I’m not suggesting that your home value will double in 10 years. Not sure where you got that idea. My point does not assume or require doubling in 10 years.
Although you're not wrong, and crashes absolutely happen, I feel like I have been hearing that for at least 30 years now.
Just when it seems like things can't continue, the market always seems to find a way to support the higher prices.
For example: https://www.forbes.com/advisor/mortgages/what-is-the-40-year...
It's probably only a matter of time until the 40 is the new 30 year loan for everyone...
Real estate is a tricky thing. I wouldn’t buy it for the sake of expecting it to go up in value. I’d buy it because you need housing.