The Chief Executive of Rio Tinto is stepping down in the wake of the destruction of ancient rock shelters in the Pilbara earlier this year.