File alsa-sof-firmware-2024.09.2-1.fc40.noarch.rpm is obsolete. Try find newer alsa-sof-firmware for Fedora 40