He will never resign. And I have serious doubts that a majority of Cardinals would ever declare him a heretic. They are the ones who are responsible for electing this dubious Pope.
There’s no need for a majority of the Cardinals. (Since this process exists by natural law, rather than Canon Law, there is no “requirement” for a majority.)
The only “requirement” is that what the Cardinals declare be the truth.