I think there was an actual prophecy saying no man could kill him. Tolkien made it Eowyn and Pippin who killed the Witch King because he thought it was lame that there was a prophecy in Macbeth that "no man of woman born" could defeat Macbeth, and he was beaten by a guy who was born by C-Section.