Susan Carter and her 10-year-old daughter Alex Carter had been missing since 2000. Their bodies were found mere hours after the man who confessed to killing them died in custody