Icons such as Tina Turner and Jerry Hall brought zinging colour to the iconic photographer’s work during the decade of decadence, but his intimate family shots captured a tenderness, too