Rate drops will make things way less affordable, it’s exceedingly obvious. If a borrower pays less in interest, the seller can ask for more money and the borrower will end up paying the same monthly payment, meaning higher home prices.
This isn’t rocket surgery, it’s Econ 101.