If you play it like a strategy game with not much feeling, you will not get depressed.
If you get read the text, feel the emotions and really get inside the story, you will probably feel depressed.
I know I did feel depressed a bit after playing it. That's actually one of the reasons I stopped after 2 playthroughs.
That's still a good game, and I recommend playing it.