Suppose crypto is adopted globaly, and 100 years pass. Where would 100 years worth of global transactions/smart contracts be stored?

To my novice understanding the blockchain is stored on all participating computers in the network. is this to say each computer has the entire chain downloaded onto the hard drive? Or do we merely query the chain from designated nodes? More specifically if i download Daedalus Main net or some other node software will the entire blockchain be stored and constantly updating eating up my memory little by little?