To put it bluntly, he's dying. His health hasn't been good in a while[1], and he's probably resigning to a) spend time with family before he goes, and b) to limit the damage to the company when he does.

[1] http://en.wikipedia.org/wiki/Steve_Jobs#Health_concerns