Comment # 17 on bug 1230115 from Takashi Iwai

By removing the modprobe.d config, now the correct driver (SOF) is loaded
automatically with the updated firmware, I suppose.

The latest sof-firmware package is on the way to Leap 15.6 update.  Will be
included as maintenance update some time later.  Until then, you can keep the
package from OBS multimedia:libs repo.