inxi data in post#4 shows that Sound Open Firmware Cannon lake driver sof-audio-pci-intel-cnl
is already loaded, so reinstalling sof-firmware would not help
If PulseAudio/Pipewire only has Dummy Output, audio devices are probably not being detected in ALSA. Replacing PulseAudio with PipeWire would not help
Audio issue with this model device was first reported in September
No sound only "Dummy Output" on Huawei Matebook D 15 (Intel)
Support for audio codec ESSX8336 was enabled in Manjaro kernels v5.16 and v5.17 in February
Cautiously enabling ESSX8336 module in the kernel
and alsa-project created the HiFi profile (to tie all the audio channels together) in March
ucm2: sof-essx8336: initial support by plbossart · Pull Request #139 · alsa-project/alsa-ucm-conf · GitHub
BUT
sofproject currently has 13 open issue reports for this audio codec
Issues: codec ESSX8336 · thesofproject/linux · GitHub
so I think the comment from February still stands
It might help to get more information about ALSA to compare with data already posted to sofproject
sudo alsa-info.sh --upload