The investigation of this particular 'sexual assault' incident cleared Hegseth. These kind of sudden accusations around political appointees or candidates always reek a bit until all the facts are known.
There's enough info floating around regarding Hegseth's proclivities to second-guess his general moral character, but that doesn't convict him as a rapist. Yet, the damage is likely irreversible. I'm speculating he won't survive the confirmation process ( if he lasts that long). I'd foresee another nominee for this position pretty soon. We'll see.