How do I see why a Mailbox Export Request failed?

You can start by exporting a detail report to a text for more detail Get-MailboxExportRequest -status failed | Get-MailboxExportRequestStatistics -IncludeReport | Format-List > c:\report.txt

I hope your report will shed light on details of the failure