> My understanding for the reason that housing prices aren't included in CPI is because nobody buys houses in cash

But they should include the sale value of houses in CPI, otherwise its pointless. Just because the vast majority of people buy houses with a mortgage doesn't mean the sale price isn't a real price