BP leader is the latest to resign over questions about personal conduct