Congratulations!!
My first visit to CS was in 2003 and I was 3 months pregnant and we had my 3 year old daughter with us too.
I was nervous about being pregnant at WDW but it didn't change anything for me. Just make sure you have lots of water and I loved all the walking it helped me stay fit even away from home. The most difficult part for me was that I couldn't go on all the rides. (but my son was worth it.)
It this your first baby? I think it was easier for me because it was my second baby so I knew more about what to expect. I think you will be fine because you are in the 2nd trimester. You are past the tired and just before the REALLY tired.
I really liked the pool at CS and I love breakfast it is so important to me (even more when your pregnant) and the Maya grill has a great breakfast buffet. I also loved the fountains around the resort. As far as the rooms go its basically your standard hotel room. I would stay there again.
Congrats again and anywhere in Disney is great as long as your in Disney
