McCarthy who also starred in "St. Elmo's Fire" was surprised by Moore's revelation, claiming he hadn't noticed the sober companion on set