The esteem of being an airline pilot died 20 years ago, it now has the appeal of being a factory worker.
Depends who you ask. Very rarely does anyone outside aviation seem unimpressed when it comes up, at least in my experience.
I've wanted to be an airline pilot since I was 4 years old. And still do. At first I was willing to do anything and work anywhere for anyone to be an airline pilot. As time went on, I considered flying for AMF instead of a regional, especially when I heard you're virtually guaranteed Oakland at the moment if you want it. Thought about it, made a lot of friends in 135, and I noticed a trend. 135 pilots, or the one's I know, tend to be the rugged, self sufficient, outdoorsy type. That made me realize that it's a pretty lonely job a lot of the time, and I really don't enjoy flying alone. Hell, I just gave it some thought last night and I've carried 21 different passengers so far in just a bit over a year as a private pilot. Like anything in life, flying is way more fun with someone to talk to next to you. And besides, working with people breaks the monotony day to day, good or bad. Its very disappointing that only one regional has a domicile anywhere near SFO, luckily its the one I work for and hoped to fly for anyway. My ultimate goal right now is to be SFO reserve on the Brasilia at Skywest, and honestly, I'd be happy doing that for the foreseeable future. I'd probably end up in Fresno first, but get senior enough there and you can hold lines that start and end with SFO deadheads, so I could still just drive 10 minutes to work everyday. Hopefully by the time they retire the Brasilia, I'd be able to hold SFO on the jet. If I cannot hold SFO, FAT, or LAX, I'd stick around only if I could upgrade, and even then I would only commute until I had enough PIC to look into Cathay Pacific(they have SFO/LAX crew bases), Virgin America or even Amflight out of OAK. Perhaps Allegiant would have an OAK base, in which case they'd be my first choice. If none of those panned out, I'd look into cooperate or air ambulance jobs around here. If I still was out of luck, I'd go back to being a CFI until I could find something local.
As you can see, airline flying is my first choice, and my passion, but it all comes down to QOL. I want to live, grow old, and die right here in the Bay Area. If everything pans out, I hope to make the majority of my income outside of flying, and gradually transition into a "hobby pilot". But my other buisness is right here, along with my friends and family, and above all else, I want to be here as much as I can. I can honestly say that if no airlines hired on the West Coast in the next 30 years, I'd happily CFI part time before I'd look for a flying job East of the Rockies.
I'll also add I personally see no point at all in setting a goal for any major airline, other than a preferred domicile of SFO/SJC/OAK. Things change so fast in this industry, who knows what it'll look like. Jetblue could buy Virgin America and become the largest airline in SFO in the next 15 years for all we know. I'll cross that bridge when I get there.