Just wanted to send all of you who are feeling this way a big hug xxx
I have had this with my current pregnancy, feeling very insecure and anxious due to a second trimester loss (at 15 weeks due to a heart condition) in September last year, am now nearly 29 weeks and only now feeling like a dark cloud is clearing. I think lot of this is due to regular scans on baby and the fact that I feel more energetic now. I have piled on the weight with this pregnancy though and am suffering with a tummy rash and awful stretch marks, so feeling hideous undressed.
I would echo what NorthLondonDoula says about actively getting in touch with mother and toddler groups, I did this when I was expecting DD2 - there is only 16 months between my eldest DD's and found it very hard work being stuck indoors with a young child and pregnant. Im not the most confident person in the world and found it hard to talk to people I didn't know. Almost all my friends do not have children and I found that I slowly stopped getting invited out and now only ever see my 'friends' on special occassions. Now that I am pregnant with DD3, I rarely see anyone who doesn't have children, which I find quite upsetting if Im honest. But I have made new mummy friends - which has been so good for both me and my daughters. It's hard getting out there for the first few times, but it gets easier and enjoyable.
As for DP finding you attractive, listen to him. My DP loves it when I am pregnant - even when I feel like an elephant. He told me the other day when I was complaining about my stretch marks, leaking boobs, swollen ankles and doubled in size bum, that he couldn't picture anything more beautiful than the body of the woman who is carrying his child. I welled up and sat there crying - not quite the reaction he was hoping for but hey, Im hormonal!!! 
It's always to come on here for moral support and a friendly chat if you find that getting out is not as easy in real life. But would strongly suggest having a few movie nights in with DP once LO is in bed and just spending quality time together. Me and DP try to do this as often as possible.
As for counselling, you could go for a session or two and see if it is any help, if not, you dont have to go back again. I was also offered counselling after our loss last year, but decided not to. MW told me at the begining of this pregnancy that it was still available to me as pregnancy after a loss can be emotionally distressing for the mother. So far I have decided not to, but this is due to the fact that I know why we lost our Cara and I have been able to come to terms with that in my own way.
I often wonder if anyone else thinks about our baby girl, but then I know that I will never forget her and will always love her, so I dont need anyone else to grieve for her. Mumsnet is a wonderful source for emotional outpouring and I have used it quite a lot, especially at the time of our loss and the early stages of this pregnancy.
Hope the dark cloud lifts soon xx And sorry for the long rambling post! xx