** corrected **
There was an update (akmod-nvidia-470xx-470.141.03-3) this morning in the rpmfusion non-free repo that fixed this for me.
I can now boot into kernel 6.0.5 with the nvidia driver.
$ sudo dnf update akmod-nvidia-470xx --enablerepo=rpmfusion-nonfree-updates-testing
$ rpm -qi akmod-nvidia-470xx
Name : akmod-nvidia-470xx
Epoch : 3
Version : 470.141.03
Release : 3.fc37
Architecture: x86_64
Install Date: Mon 31 Oct 2022 01:09:10 PM EDT
Group : Unspecified
Size : 95109
License : Redistributable, no modification permitted
Signature : RSA/SHA256, Sun 30 Oct 2022 06:58:03 PM EDT, Key ID 6a2af96194843c65
Source RPM : nvidia-470xx-kmod-470.141.03-3.fc37.src.rpm
Build Date : Sun 30 Oct 2022 06:13:05 AM EDT
Build Host : buildvm-07.virt.rpmfusion.net
Packager : RPM Fusion
Vendor : RPM Fusion
URL : https://www.nvidia.com/
Summary : Akmod package for nvidia-470xx kernel module(s)
Description :
This package provides the akmod package for the nvidia-470xx kernel modules.