Is it worth it? Spending loads of money and years?
I'm not a pilot myself, but can provide some links here:


Burdens of working as an airline pilot
Do pilots make a lot of money?
Why is being a commercial pilot stressful?


You may also ask on PPRuNe discussion board, which is more suited for this kind of questions that are a lot based on individual opinions.

Here is an interesting article from Vanity Fair, that I often cite, about the increasing automation of aircraft, and the related impact on crew members: The Human Factor. The article starts with "Airline pilots were once the heroes of the skies. Today, in the quest for safety, airplanes are meant to largely fly themselves", which gives the tone.