The human pilot will always be better than the computer at certain tasks.
But the computer will always be better than the human pilot at certain other tasks
Hit the nail on the head. That's why we build computers with only so much authority now, and the ability to turn them off if necessary. With TCAS, EGPWS etc, they advise the pilot, and it's left to him to take final action.
Ever had the EGPWS go off in cruise at FL350? How about a defective radio altimeter triggering a configuration warning on approach? What would your computer do?