Pero said it so well. Your husband needs to rely on the professionals and if available he should find a male abuse support group. I have my two support groups to be invaluable, speaking with people who know the pain and devastation the abuse caused in our lives.
You do need to take care of yourself. You need to ensure the children are not brought into the issues he is facing nor should you use the children as your confidantes--especially if the are young. Be supportive as you speak about your husband to the children and family. But take care of yourself, you may want to find a therapist to help you through dealing with your husband's CSA. Make sure the therapist or doctor is qualified in trauma and PTSD--many are not and give unhealthy and false guidance--many medical professionals cannot accept they are not all knowing.
I do hope the help your husband is receiving allows him move forward. Crying and feeling lost is common, I struggled a long time--it was the nightmares and flashbacks that brought these emotions to the forefront. As you husband talks about the abuse and ultimately accepts the abuse and not allow it to control his life, he will find life rewarding and full of kind and compassionate people. You are courageous and innately kind and compassionate to be concerned and wanting to protect him. You are there for him, but you need to there for yourself and children. Balance is important but being an attentive ear or a kind smile is so important. Unfortunately, the work is on him to heal, but those around him should not make him feel re-victimized or abused so as to trigger the past over and over.
Take care of yourself and I wish both you and your husband heal.