well, that all depends on how fast technology progresses in the areas of storage sizes of SSDs/HDDs and how powerful CPUs get. And how fast internet connection speeds can get. Even with all of that new tech, if prices stay high and keep them out of reach of normal people I mean who is going to pay $700 to get a 30TB HDD? just so they can store the blockchain?

That's why they say with larger block sizes bitcoin becomes less decentralized because not as many full nodes...but on the other hand, there does seems to be a serious problem that bitcoin can't scale and needs layer 2 solutions. if they come up with a way to throw away all the X oldest blocks periodically then that could guarantee the blockchain never gets bigger than a certain size and then you could have block sizes as big as you wanted.