Viewers were left stunned at the 82nd annual Golden Globe Awards when Demi Moore recalled a cruel conversation with a producer and says she recently came close to giving up on Hollywood