Demi Moore almost lost role in ‘St. Elmo’s Fire’ to this megastar, after showing up ‘drunk and high’ to a fitting