U.S. home prices continued to march higher in August, according to S&P data, even as the housing market grapples with an ongoing spike in mortgage rates.