Infidelity counseling?

I have found my husband texting female coworkers on 2 different occasions, with 2 different women talking very sexual and flirting. The first female sent him pics and things, the second one was asking for a massage from him and saying she wishes she was with him. Both times I confronted him he didn’t give me any details and deleted everything before I could read any other messages. He has since blocked and deleted the numbers and I haven’t caught him again but obviously I’m not over things, he cheated clearly, I know that and I probably look stupid for still being married to him but really want to give him the chance to be a good husband. We’ve never done marriage counseling before and I want to start as soon as the world goes back to normal but now I don’t know if we should be in infidelity counseling or if they are the same thing? I’ve definitely got my head up in the clouds hoping he’ll realize what he’s throwing away and that he’ll change but I don’t want to not give it one last fighting chance. If he physically cheated I know I’d never be able to look at him again but although it’s still terrible and cheating emotionally I can somewhat find a place to give him another chance. Have any of you ladies been in my shoes and seen a change or am I really just stupid for being with him?