The Photographers' Gallery retrospective explores five decades of the long-overlooked artist's career—from cruising on street corners to Aids activism