Husband cheated (all advice welcomed )

So my husband and I have been married for a year and together 4 . We had so much trust and love between us ; we were best friends . His job sent him for a year contract; about 7 hours away.

Also ; he is 35 and I’m 29 .

These past 6 months have been good ; we communicate a lot and see each at least twice a month. July 5 I woke up to text from him telling me he was at pool party the day before ( which I didn’t know it was party thought it was just friends hanging out ) he told me he got drunk and high after being sober for a year ( we both are sober for religion purposes ) He met a girl at the pool and had sex with her at her place ( without condom but says he pulled out ) . He told me less than 12 hours ; as soon as he sobered up .

How would you ladies handle this situation ? Would you consider his honesty ? Everything you had before this ? All advice is much appreciated ( even its different opinions just pls be respectful to others in this group ) thank you