The photographer was a key figure on New York’s downtown scene – but, as a new exhibition shows, his later works dealt with the great losses of the Aids crisis