That's only one of his attempts at resignation. If anything, it seems like he hated his position, wanting to just retire and do small party work without the intense stress that came with his position. He even advocated eliminating it entirely, as he believed there was no need for his 2 positions given the collective nature of Soviet leadership.

That doesn't mean he was some selfless great man, either. He had his fair share of errors, even the CPC considers him to have been 70% good, 30% bad. However, simply saying he only tried to resign because Lenin was angry at him for insulting his wife is wrong, he seemed to have hated his position for his whole career until his death.