most of heat generated in CMOS like in every digital chip since 80s comes from transient shorting of source voltage during switching between states. you can't help that with superconductors. You can decrease heat load by either lowering voltage (bad for stability below some point), lowering frequency (your phone/pc already does this when needed) or making the transistors smaller (hard but worthwhile) and improving chip design in general