With Fedora 37 release I gave it another go.
After a clean install of Fedora 37, the WIFI was still not available. DMESG reporting the same issue.
I did a bit more research and found the board2.bin files in:
Copied all the files from hw2.0 as is (no compression) into /lib/firmware/ath11k/WCN6855/hw2.0 and did not touched the other files on the location.
Reboot with fingers crossed and it worked!
I now have WIFI available in my system!
Hope this can be useful to any1 facing the same issue.
(Do backups before making any changes in case it does not work)