Regardless of its sobering themes and unavoidable heartbreaking ending, Whitney is still a celebration of the singer’s legacy