It all depends on Pinhead. From a comic stand point he is a lesser to mid demon that Superman is levels and levels above. But from the movie stand point is a being that is beyond mortality and would rip Superman to pieces with kryptonite hooks and chains for eternity.
Its kind of like "If a tree falls in a forest and no one is around to hear it, does it make a sound" 1) if sound is the vibrations the tree makes when it falls, then yes. 2) if sound is what happens when said vibrations come in contact with your ear drum, then no.
same with this. I this a superman that is a mortal and can be effected by demons, or is he the superman that only the strongest demons can stand against. Does Pinhead have absolute power over mortals or is he just strong enough to bully humans.
going from movies to comics is hard because the power levels are different.
my opinion. From a comics point of view Pinhead would barely register as a threat to Superman. From a movie point of view Pinhead would destroy Superman.