Christa Pike was heard loudly snoring despite being given two doses of pentobarbital during her execution procedure, leading a state governor to launch an investigation into the events