Jerome Powell has indicated he wants to see the housing market correct. Unfortunately, real estate agents and sellers are slow to react. You don't just immediately drop your price to match the payment.
In Bay Area, houses effectively dropped from 2 => 1.85. They should drop 150K; but with the latest interest rate hike of 5.2->6.2 you'll see 50K price drops as buyers/sellers adjust. In reality, prices are still dropping as we bounce off the unreasonably low interest rate of 2-3%.
The interest rate will act as a gravity on prices, but housing prices won't immediately "snap" to the new normal. You'll see house prices begin to crash in a few months as a lagging effect.
On top of this, you'll see new home builds get put on hold, because the builders specifically won't be able to find people to buy a new house for a high price; their margins will be squeezed. With existing homeowners, they can at least hunker down in their well financed 30 year fixed rates.