Planes are typically in service for decades but if they could eliminate the pilots, that could very well change the calculus.
But, public mistrust of a pilotless plane might very well put the kibosh on that for a long time. People have trouble trusting air travel as it is, doesn't matter if it's irrational, and they usually know that it is.
Imagine a lottery where instead of winning, you die in a terrifying way.
That's flying. You enter into an aluminium can, and from that point you are completely helpless, whatever happens. The only thing you can do if something goes wrong is assume the fetal position and hope.
And yes, life is pretty much like that. You could get cancer or get hit by a car or a meteorite for that matter, but even these things feel more controlled. I can pay attention to my surroundings to avoid getting hit by a car. I can potentially treat cancer. I could probably not do much against a meteorite or gamma ray burst or whatever cosmic thing might happen but that stuff feels less real anyway.
I agree that the fear of flying is somewhat irrational, but at the same time I think it's a valid fear especially in light of things like Russia shooting down passenger planes, the whole Boeing Max 8 thing etc.
But, public mistrust of a pilotless plane might very well put the kibosh on that for a long time. People have trouble trusting air travel as it is, doesn't matter if it's irrational, and they usually know that it is.