Sometimes I get overwhelmed thinking about exercise too. But then I say to myself to just go do something... whether it be walking, going on my elliptical machine or doing pilates. Once I start, I usually don't mind it so much. And I'm setting realistic/achievable workout goals for myself so I'm not discouraged from the get-go. I work full time and have 2 & 3 year olds boys (not to mention my husband!) but tell myself I can find at least 1/2 an hour a night to focus on my weight loss and exercise. If I tried to tell myself to do more, there would be too many nights I'd find an excuse of why I couldn't devote an hour, let's say, and not do anything at all.
Also, do whatever you enjoy. It may take a few experiments to find out what that is. I find what I like best is using my elliptical machine with my favorite music blaring AND reading a magazine- makes the time fly! I also just bought this great new pilates DVD that uses a resistance band with these incredible beach scenes in the background... it's so calming. (It's called Pilates Body Band Challenge). Good luck!