Bovine Manure
Pilots don't have a perfect public-perception record, but overall, we're held in pretty high regard. People believe...or want to believe...that the guys up-front are there to safely take them from A to B.
Until the average person can buy a computer that never requires control-alt-delete during the life of the computer, or never lose a cell-phone signal, or can drive a car that never breaks, they will prefer a human pilot aboard.
For now, automated aircraft can carry "virtual passengers" to ethereal website destinations. They can file virtual-complaints for their "First Gig free; second gig, $25.00" virtual-baggage fees.