The two-hour documentary covers the final six years of the Black Sabbath singer's life and features intimate footage of his health battles