I just tried it:
* On Safari it works correctly with default settings.
* On Chrome with third party cookies disabled it doesn't work and takes you to https://support.google.com/drive/answer/2423534
I poked around in dev tools, and it looks like what's happening is in serving to Safari it gives a download link that includes authentication information, but when serving to Chrome it doesn't. Perhaps because it's expecting to get third party cookies?
My guess is that they rolled out special handling for Safari when it started blocking third-party cookies by default, which will eventually make its way to all browsers?
(Disclosure: I work on ads at Google, speaking only for myself)