Christa Pike, 50, remained alive and loudly snoring after the attempted lethal injection