It’s clear that Riker was able to go on some kind of extended sabbatical while retaining his command, I’m not sure why he chose not to do that?

Picard retired as a protest. A protest sabbatical just wouldn’t hit the same.