Except that as you say, it's too expensive for every node to have a full copy, so there will only be a few dominant players. If that's the case, web3 will be like what we have now, where instead of the dominant players being Google, Meta, and Amazon they will be the two or three dominant web3 companies, with a few smaller people trying to keep up.
So I would agree with your last sentence.