You are both lucky that your husband wasn't hurt. I know what a loss a car is, but it's materialistic and can be replaced where a human life can't.
If this is a first and only episode of falling asleep at the wheel chalk it up to working too much. If it recurs I would encourage him to talk to a physician about it...our son has a condition that causes him to do this. Luckily it can be controlled.