I appreciate your honest answer. I want to completely own my data, so I would not go the Cloud route. After all the Cloud is basically someone else's computer.
there are many ways to encrypt locally and store the encrypted data remotely; either a container (like veracrypt), or individual files with a file-based encryption schemes (such as cryptomator) or one of numerous backup or sync utilities with built-in encryption.
Yes, that may be an option.. except that google can irreversibly lock you out of your account, or they can delete your files if their content scanning think it goes against some of their terms, but also simply there are people who don't want to lose their privacy to google.
It's more likely that a Google data center exists in 100 years than your house. If you have a personal aversion to it then I can understand - but, realistically, it's more likely that an offsite copy on Google Drive exists in 2123 than a random piece of furniture you own - and furniture is pretty damage resistant.
Good for a 3,2,1 backup method but bad for archival. We don't know if google will even exist in whatever number of years OP wants to archieve for or if the data will be deleted/modified by google themeselves due to some crap policy like their 2 year inactive account one for example. Just too many factors that will be out of OP's control