Christa Pike's botched execution attempt took a serious toll on her ... with her lawyer saying she's in bad shape in the hospital -- but making it clear she's not in a coma. An attorney for the convicted killer tells TMZ ... "Christa is critically…