There are probably only two or three armies in the game that don't have a hard counter to superheavies.
Necrons can glance or eat them to death, SM of all types and colours have Termicide, Lance weapon and haywire laugh at your superheaviy, and even Orks can manage to be dangerous.
Of course a lot remains in the hands of the skill and luck of the players.