In 1987, she became the third wife of a wildly successful actor-singer, but their union would become strained over his struggles with alcohol until they split in 1993