Pelley, a fixture at CBS News for nearly four decades, had become the most vocal internal critic of Weiss’s overhaul of the network.