I have some experience here. I was a full time working girl ... marketing manager with an MBA.... we ended up moving and I had to quit my job. We didn't have any kids at the time and I was burnt out on the corporate world... so decided to go into Real Estate. I got my license in Michigan. Did it for a couple of years and then we ended up moving overseas for DH's job.
Here's the thing.. you don't HAVE to be bubbly to be an agent. What you DO need to do is work your BUTT OFF. Seriously. I will not go back into Real Estate for several reasons. 1) You work very very hard for very little return. And much of your work never pays off. 2) You are on someone else's time schedule... not your own. Sure, those who have been in the business for years and years and have a ton of repeat business can set their own schedule, work only 9-5 or what not... but newbies.... not so much. You have to be "on" when everyone else comes home after work. People only look at houses after work or on the weekends. 3) you're ALWAYS waiting on someone else. Buyers, Sellers, Other Agents, Banks... there is always someone or something holding up the process or not returning calls, etc....
It can be a lot of fun... but it's a tough tough business. Honestly, this is not a job that will allow you a lot of time with little ones... not if you want to actually make money.
To make money you have to go out and beat the pavement... call on For Sale By Owners homes, look for old listings that went off the market and see if they want to be back on the market, talk yourself up to friends and family to gain business, and in many cases ... get really really lucky. You spend a lot of time learning the processes, sitting in open houses for other agents (the seasoned agents often don't like to sit their own open houses and it can be a good way for you to get your name out there with potential buyers), and just finding any way to drum up business.
I'm not trying to discourage you ... just give you the facts. This is how it is. If you can get through the initial newbie trenches and get some good business... then yes, it can be very profitable. But it's a lot of very hard work.
The other thing... many seasoned agents do NOT want to hire you as an assistant if they know you eventually want to break out on your own. They are afraid you will take their clients. I tried that approach... got shot down a few times.
If you can get on a team... that is good. You can be a specific buyer agent, or seller agent .... etc... If you really want to just work part time and have a good amount of flexibility then become a licensed assistant. Get your license, and then just pursue the assistant job. You can work it out with your agent how much time you will put in, what you're willing to do etc.... And also, you're not the one who has to handle everything.
Good luck!