Since transubstantiation is Roman Catholic Dogma, are self described Roman Catholics who reject it in heresy?

The answers and comments to this question have made it clear that transubstantiation is a Roman Catholic Dogma. Of Dogma the Catechism of the Catholic Church states: > The Church's Magisterium asserts that it exercises the authority it holds from Christ to the fullest extent when it defines dogmas, that is, when it proposes, in a form obliging Catholics to an irrevocable adherence of faith, truths contained in divine Revelation or also when it proposes, in a definitive way, truths having a necessary connection with these. Every Roman Catholic is obligated to irrevocably adhere to Dogma in order to remain 'in the faith': > If a baptised person deliberately denies or doubts a dogma properly so-called, he is guilty of the sin of heresy [...], and automatically becomes subject to the punishment of excommunication". - Ott, Ludwig (n.d.) [195X]. "INTRODUCTION — §4. Concept and Classification of Dogma – 1.". In Bastible, James (ed.). Fundamentals of Catholic Dogma. Translated by Lynch, Patrick This 2019 Pew Research Center survey indicates that only 1/3 of self described Roman Catholics in the United States agree with the Catholic Dogma of the transubstantiation of bread and wine into actual flesh and blood of Jesus Christ. The survey goes on to say that 69% of those surveyed personally believe that during Catholic Mass, the bread and wine used in Communion “are symbols of the body and blood of Jesus Christ.”. Availability and reception of accurate teaching does play a significant role but it is not solely explanatory: Of that 69% who hold memorialist views, 43% do not know or understand the Church's teaching on the matter. Of the 31% who do believe in transubstantiation, 28% know the Church's teaching. However, of the 69% that hold memorialist views of the Eucharist, *one-in-five Catholics (22%) reject the idea of transubstantiation, even though they know about the church’s teaching*. It is this last category, **the 22% of self declared Roman Catholics in the United States who know about the Catholic Dogma of transubstantiation and yet reject it in favor of a memorialist view**, that I ask about: According to the Roman Catholic definition of heresy and the Pew Research survey, are 22% of Roman Catholics in the United States heretics and automatically subject to excommunication?