Here’s a powerful exploration of a dissolute older man’s waning fortunes and the shock that brings him out of his apathy, writes TOBY WOLLASTON