I don't think Cameron should resign. The real wrongdoing is with News International and the police.
Just like the expenses scandal both Labour and Tory are culpable. Politically, it's better to hold up your hands, own up you got it wrong and move on.