The two-part film debuted June 4 at the Tribeca Festival, offering an unprecedented look at the personal crisis behind his music