If you expect to be successful and you expect to raise a family while having a career then you will strive for that; if you strive for it then hopefully you will achieve it. So I think for my own daughter, she's going to grow up with a working mom. One that has had to make some painful choices and face some painful realities.
The problem isn't that the green jobs aren't sexy enough. It's that they're not plentiful enough. A young person looking for a job isn't looking just for a sexy job, they're looking for any job.