For what its worth I see exactly the same thing on RockLinux 9.4 (with kernel 5.14.0-427.26.1.el9_4.x86_64, not sure if that’s relevant), using:
dnf config-manager --add-repo https://developer.download.nvidia.com/compute/cuda/repos/rhel9/x86_64/cuda-rhel9.repo
dnf module install nvidia-driver:latest-dkms
dnf install cuda
Again using cuda-12.5.1 appears to install OK.
I have also noticed though that the nvidia-driver module doesn’t behave as documented wrt kernel- packages, see Nvidia-driver installs kernel-{core,devel} even if correct versions installed [edited to add link]