Thank you for your help, you were right, it was not a permissions issue but a theme issue.
I followed your instructions in the export stuck troubleshooting guide and during the process of enabling wordpress debug log file, I saw the error with my theme. It was a simple fix of removing the themes broken code and now the export works!
I’ve reported it to my theme developer too.