The Academy Award-winning documentary is a “dark and painful” tale that sadly shows how she was destined to die young and join music’s “27 Club”