Senior pastor resigns after cheating on wife