In an effort to arrest his slide into middle-aged bloat, he attempted a ‘Proustian’ novel, but spilling the secrets of the women he claimed to love was social suicide