An absorbing retrospective of the painter’s studies of friends, family and local streets reveals an intense quest for understanding