This video would be interesting. My advice would be just learn what you're getting yourself into especially for airline pilots [well in the U.S. at least]. I went to an aviation school, graduated and am working as an instructor for the school now. I have seen a lot of my peers drop out and/or change careers because they found out it was a lot different then what they initially thought. Expect to spend $40+ for flight training to get your commercial certificate and 250 hrs, most build hours by instructing CFI/II. Get hired by a regional airline when you have 1500hrs and then just move up the ranks to a major airline. If you have any more specific questions I'll do my best to answer them.

Edit: $40,000+ not $40 dollars.