Christa Pike’s advisor reveals what happened when she woke up from botched execution