As a new exhibition opens at Tate Modern, Michael Hodges reveals how the French master overcame it all to produce the work of his life.