At this point the advice is moving towards "Don't even have a video if you can't be bothered designing a CPU from scratch to host it on".
Keep a local backup by all means but it's far more likely the local copy will get lost than the google drive copy.
Obviously, if your website is running a complex stack this is fairly infeasible (good luck keeping a complex web-framework secure without vigilance!) But if it's just a static site... and static sites are the fair comparison to google drive.
The issue with google drive and similar products is that they're actively - very actively - maintained. Stuff doesn't just break because it's taken offline, but because there are changes in terms of service, there are automatic deactivations for inactivity, there are plain old incompatible upgrades, etc, etc, etc.
I mean - I totally support people starting with the minimal effort (which is surely some freemium service like google drive), and leaning to live with the limitations - but the risks of a server (whether physical or otherwise) if you're similarly conservative and willing to live within constraints not unlike hosting on drive seem overblown - people talk as if servers burn down all the time, and hackers crack everything, but nothing could be further from the truth - those are exceedingly rare circumstances. And for many things, those risk are just OK. Don't keep your only copy of the data on the box, and don't keep private stuff there, and if lighting really strikes - it's not so bad. And both strategies will need a little TLC once and a while, that's just the way it is.
None of this is stuff the average company needs to deal with when youtube works just fine. I'm sure you can list out all the ways to avoid those listed problems but that just shows how much work and knowledge is needed to pull this off while anyone can use youtube.
You know that this requires some uncommon computer proficiency?
The Google drive could be deprecated at any moment