I wanted to correct this, having just re-read it. I think I am wrong here, or may be wrong.
A more obvious explanation for Rose writing himself into the lineup when he was old and no good anymore is just that he couldn’t stand to not play baseball. I am reminded of Rickey Henderson, who refused to retire and kept playing minor league ball after no MLB would sign him because he simply loved playing and didn’t know what else to do. To someone like Rose… I mean, being an MLB player is all he had ever been. It was the only job he’d ever had, it was his life and identity. To give that up is to give up who you ARE, to move into a life you have no familiarity with, no anchor, none of the structure you have now spend your whole adult life living within. I think I can understand why one would be unable to let go.