The biggest-ever exhibition of the iconic photographer's work challenges us to rethink intimacy and discomfort.