A man charged over the death of a sex worker will no longer face a rape charge after a magistrate found their was insufficient evidence to convict.