I would look into the rest API to export this. SonarSource has a json based REST API that should be relatively easy to query with Python’s requests library for example.
It is not explicitly documented but you can look at https://sonarcloud.io/web_api
We have not used it yet, but the link used to be present at the bottom of the pages and still works.
curl -u <token>: -i -H "Accept: application/json" https://sonarcloud.io/api/authentication/validate
curl -u <token>: -i -H "Accept: application/json" https://sonarcloud.io/api/user_tokens/search
curl -u <token>: -i -H "Accept: application/json" https://sonarcloud.io/api/projects/search\?organization\=<your_org>
Note that you will have to create a token, and that token replaces your username, and password becomes empty.