I'm a Realtor (two syllables), and I may be able to give you a little advice and insight.
As to what it's like? It's an emotional roller coaster, full of stress. Not scared off yet? Ok, here we go.
I firmly believe that the key to being a succesfull Realtor, is dedication to the job. If you're not prepared to put in long hours, miss family events, work days and evenings, have people stab you in the back and be ready to pull your hair out multiple times every day, then Real Estate is not the job for you.
That being said, if you love to work, meet new people every day, are a self starter, are a good communicater, are patient, are willing to live without a bi-weekly cheque, and want to have a potentially huge income without years of schooling, Real Estate may be the career for you.
Being the ultimate schmoozer is not necessary, but it doesn't hurt. What's more important, is being fairly well connected. The more people you know, the more potential business is there for you. To be succesfull, you need to be meeting new people, and letting them know what you do for a living. Getting to know the in's and out's of the local Real Estate market, is fairly simple. But dealing with people, and making them feel confident in trusting you with the largest investment they are likely to ever make, is trickier.
I would suggest having enough money to live for five to six months without earning a penny, as the business is very expensive to get started. My biggest piece of advice would be to look into becoming a licensed assistant for an established agent. That way you can learn the ropes without a huge monthly bill.
If you have any specific questions, feel free to fire away.