Most mirrors (at least within the US) are now up-to-date. I finished installing pacman 6.0.2-7 a few minutes ago.
I got some issues with all my mirrors: the size of the last pacman package is very (too) small (60 vs 944412 for previous version). e.g. https://archlinux.uk.mirror.allworldit.com/archlinux/core/os...
I would try and generate a new mirrorlist for your locale: https://archlinux.org/mirrorlist/
I picked a mirror that definitely has the 6.0.2-7 version on it[0], yet Pacman can't find it.
Does the server's core.db have to update before the new version is available? Because that one is dated 18-May-2023 05:21.
https://archlinux.org/mirrors/status
still seem unsynced on my arch systems.