John I missed an email from you asking me to download the 2022 entries month by month. I did that and realised that it was corrupted photo uploads (where the photo was just a grey holding image) that were stopping certain months from downloading. Sure enough, when I deleted said photos, the exports worked. Same with 2023 entries. I hope this helps anyone with similar issues.
Also, the 'download tags' tick box has to be unticked, or only posts with tags will export!
I did notice an oddity with the timezones, but I'll create a new post for that.