You only need one of those every 40 years until then the shock is simply worth more. Apple etc don't need that money it's simply in a holding pattern until their shareholders get it.

One tax holiday every 40 years doesn't overcome the disadvantage of super high corporate tax rates every year. Apple shareholders would have already reinvested most of that money in the US, instead its increasing Irelands productivity,

That's a common misconception. The money can go to the US, it simply can't go to shareholders. Apple could for example have a subsidiary buy a lot of US treasury bonds.

And that subsidiary would also be more likely to put the equity investment portion of that money in US vs. International businesses if the income tax rates were lower.