The Catholic Church teaches there are things which are yet to come. A tribulation time, an anti-Christ figure, the Second Coming of Christ, the Final Judgement, and then our final place in the heavenly kingdom. So yes, denying any of those things is contrary to the faith. It would be Especially heretical to deny the Second Coming or Final Judgement.
So, yes, Hyper Preterism or Full Preterism is heretical and contrary to the Catholic Faith.
However, within bounds, Partial Preterism which sees a lot of allusions and fulfillment of biblical statements in the destruction of Jerusalem in A.D. 70 is an acceptable option which is held by many Catholics, such as Scott Hahn. I myself have some Preteristic interpretations of certain passages, so I am somewhat of a Partial Preterist.