I understand your concerns, many feel that the Church is against women or wants to keep women down. I feel that this is a exact opposite of the truth.  
 
Yes, the Church supports a very traditional household, one working parent and one stay at home parent. Traditionally the husband works and the wife stays at home, but this is not set in stone.  
 
The important thing is that once a family starts having children that someone is home to raise those children properly. Our nation is falling apart because parents no longer stay at home, they seek selfish pleasures and leave there children to be raised by TV, XBox 360, and vulgar popular music.  
 
Now the Church does expect a parent to stay at home to rear children, and they by tradition lean more towards a stay at home mother. This is not a requirement I know plenty of stay at home Dad's. I feel that most feel that a mother by nature is more nurturing but this is not the case for each situation.  
 
The Church does not in any way, shape, or form try to repress or hold back women though. Such accusations are unfounded and baseless.  
 
LDS women have the highest rates of graduation for college among all Christian women.  
 
We are strongly encourages man and woman to attend college or another type of educational institution to further or knowledge and make us more self reliant.  
 
It is correct that many LDS wives will leave the workforce to raise there family, but this is a sacred sacrifice that they make. It provides them with ample opportunities to learn and experience the joy and trials of raising children.  
 
A full time mother is hardly "not stimulating enough for an adult brain" as you state. Learning to nuture and raise a child from birth to adulthood is the most mentally challenging task any human being can undertake and no one can do it alone. Husband and wife are both needed provide the best environment for a child.  
 
LDS women are also encouraged to be educated because it increases the self reliance of that family. If there should be a sudden loss of one parent due to sickness or injury then the other parent can still provide for the family and utilize other family members to help provide the nurturing for the children.  
 
I respect that you desire to get a job and have a career after college, this is a noble and admirable desire.  
 
I disagree thought that one must is not stimulated and constantly learning while as a full time mother, at home with her children. 
 
Parenthood is one of the most important parts of eternal progression. It is so important that President David O. Mckay taught, "Again, no success can compensate for failure in the home. For if you have failed at home you have failed eternally."

I thought this new video was timely: Link