Although I am not aware of any official Church pronouncement concerning Edgar Cayce, I think it is safe to say that the Church would not be in favor of his practices.
The type of practices Edgar Cayce participated in, such as channeling, definitely falls under the condemnation of occultic practices in paragraphs 2116 and 2117 of the Catechism of the Catholic Church.
Whatever messages Edgar Cayce received during his trances would not be coming from righteous spirits but from evil spirits. Consequently, the church would not deem them as authentic revelation.