People always warn that this setup can corrupt your stuff, which I understand you definitely wouldn't want to try to share Git via Google Drive.

Obsidian shows a warning about this. But the only issue it's pointing out is that mixing Obsidian's built-in sync with something that syncs your files is likely to cause problems. Otherwise it's a perfectly safe and normal way to sync.