To "download" a WhatsApp backup, you typically need to restore it onto a device, as backup files on Google Drive and iCloud are encrypted and not directly accessible for viewing.
The most common way to access your backup is by restoring it during the app setup process on a phone. Download Whatsapp Backup From Drive - Google Groups download backup in whatsapp