I don't understand the dichotomy. Local stores can exist and their taxes can pay for things, but the Amazon HQ also exists and can pay for things. And its employees likely pay the higher taxation bands as well, although I could be wrong.
The local stores still support those higher-paying roles, though again probably more locally — the local accountant, the local lawyer when they need one, the local IT company.
The Amazon HQ is great for Seattle and Luxembourg, but money spent there is gone from my local (or even national) community.
This is mostly the case from imports, though, isn't it? Anything you import rather than buy locally is money leaving the country. That seems to be by far the bigger effect if that's what you're concerned about. Ireland's situation, if I understand it correctly, is still to pull corporation tax from Amazon sales in Europe, just at a lower rate. So Ireland is going to be a massive net beneficiary, even if you only take into account the corporation tax paid by Amazon and not the larger effects (other taxes; infrastructure investment; etc).
