June saw the highest share of canceled purchase agreements since the start of the pandemic. The likely culprit: lending rates.