I'm even struggling to come up with counter examples where a major established company is able to successfully pivot when the business model that brought them success is no long as viable as it once was. Maybe IBM counts in that they still exist, although I'd argue they aren't nearly the omnipresent force they were back in the day. You could also count widely diversified companies, but I probably wouldn't because they never really have to try to pivot the entire business.
As you said, finding a balance is hard and maybe not truly possible.
Nintendo and Netflix are the only examples I’ve got.
Intel famously pivoted from memory. Maybe it’ll still get to where Pat wanted it to go as a foundry in its most recent pivot attempt, unclear yet.