You asked

Husband scared of sex in pregnancy - is it normal?

It is totally normal for some men to be scared of sex while their partner is pregnant. Men can sometimes fear that sex could hurt the baby or they find the notion of having sex ‘in front’ of their unborn child as strange and can make them uncomfortable. For some men it’s more of a psychological issue where they now see their partner as a mother rather than their lover.
It can be particularly unfortunate timing for your partner to go off sex as it is a time when women want it the most. A woman’s hormones are racing during pregnancy which is likely to increase her libido significantly. So it can be especially frustrating for a pregnant woman when her partner is turned off sex. But remember this is not a reflection on you, so as difficult as it might be, try not to take it personally.
Don’t reside yourself to a 9 month dry spell just yet though. There are things you can do to try and improve the situation. The most important thing is to talk to your husband and find out what it is that’s bothering him. Whatever his answer, do not get angry. This cannot improve things. Be patient and encourage him to communicate his issues. Once he has voiced his problem he might feel a lot better about it and be willing to give sex a go. Reassure him that it is perfectly safe to have sex while pregnant and that baby will be totally oblivious to what’s going on. If he has doubts, give him one of your pregnancy books to read or bring him along to your next doctor’s appointment.
The next time you try to have sex, set the mood with soft lighting, some music and sexy lingerie to entice him and help him forget about his hang-ups. Hopefully he will be able to let go of his issues for a little while and see you as his lover again. 
Don't forget to look for baby names... Search now

More questions

Men can can often be worried about sex while their partner is pregnant
While your partner can't go through morning sickness on your behalf, there are things he can do to help
Sex is generally not discouraged during pregnancy, not even in the third trimester, but certain bodily changes can make the experience difficult.
Having sex during pregnancy
There are many factors that need to be taken into consideration about sex when your partner is pregnant. 
Is it safe to use sex toys during pregnancy? 
Anxiety or worry about gaining weight during pregnancy is normal, but not necessary.