I found this post#2 in MediaTek Device 7922 wifi not working which suggests:
I solved that last error by doing a cold boot, seems it’s a known issue for this wifi/bluetooth chip. It’s performance also seems to be a bit up and down. Worst case i can swap it out for one with higher linux compatibility.
… which points to mt7921e 0000:09:00.0: hardware init failed as the source for this revelation:
MediaTek is known for its bugs. Check, that you are running kernel >= 5.18.
After this, you should unplug your pc from the outlet or turn of switch on the PSU. Then spam turn on button multiple times for several seconds to discharge capacitors on the motherboard. Wi-Fi controller will reset its internal state and will start working after this.
These may (or may not) be related. Still, it will be interesting to confirm or deny the purported resolution.
The USB-WiFi GitHub page may prove interesting reading, generally.
Otherwise, choose a replacement based on known and demonstrated Linux compatibilty, rather than price. That’s all I can suggest. Cheers.