It doesn't sound risk free, but in a reasonable world, the risk would just be accidentally downloading a virus or something and having to wipe your PC, not being unpersoned for life by Google.
The name "Google drive" implies it's like a hardware disk: unaware of even the filesystem, much less the files, stored on it. Most users likely think of it that way and don't notice until they accidentally trigger things.
People have been saying “The Cloud is just someone else’s computer” for decades. We still apparently have not fully internalized this fact. It’s only your data if it’s on your metal, in your physical possession.
But still, "unzip random NSFW content onto Google Drive" doesn't sound risk free does it