A rare behind the scenes look at the tragedies and bitter disappointments that plagued one of MGM's most popular leading ladies