Edit: I think I see where the confusion is. You are right that the literal supply of houses doesn't increase or decrease unless people stop/start renting or new homes are built. But the supply of houses available for purchase depends on whether people want to list them right now or not. Which is influenced by current prices because most people won't sell at a loss unless they have to.
So, to a first order approximation, there is no change to ratio of supply to demand. The absolute level or supply is irrelevant. The absolute level of demand is also irrelevant. What matters is the amount of supply relative to demand.
It does not matter to the overall supply and demand picture if someone “can’t afford to sell” because they also can’t afford to buy. People who do have to sell will get fewer offers, and so people who are still in the market to buy have less competition.
What really matters is how many renters are converting to buyers, how many owners are dying or moving to nursing homes, and how many investors are buying or selling rental units. Higher interest rates tend to have little effect on mortality, but do discourage first-time homeowners and investors.
I also understand that current sales will sell for less because there is less demand. That's why I mentioned that sales comps will be pegged to the few transactions that occur. But you have to look at the number of transactions, not just the most recent prices. In real estate you have a price cycle but also a volume cycle. Fewer transactions occur at low prices because sellers don't want to sell when prices are low. The exception would be if many people are forced to sell because they can't make their mortgage payments, but that doesn't appear likely at the moment.