I see what’s happening. We released updates at 07:00 GMT and not all mirrors have synced yet. And from what I can see, the mirrors you’re connecting are not completely in sync… For example your appstream mirror is correct but your baseos repo isn’t.
I would try to dnf clean all and dnf update again and see if you can catch mirrors that have synced. Alternatively, you can change /etc/yum.repos.d/rocky.repo under [baseos], [appstream], and [crb] to use the baseurl instead of mirrorlist. Example:
[baseos]
name=Rocky Linux $releasever - BaseOS
#mirrorlist=https://mirrors.rockylinux.org/mirrorlist?arch=$basearch&repo=BaseOS-$releasever$rltype
baseurl=http://dl.rockylinux.org/$contentdir/$releasever/BaseOS/$basearch/os/
gpgcheck=1
enabled=1
countme=1
metadata_expire=6h
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Rocky-9