This WiFi card (which works mainly for monitoring mode) was not getting detected by Kali (2023.2 as of now) and I had to just install an extra package to get it working properly:

sudo apt update
sudo apt install firmware-atheros

Unplug and plug it again, and voila!

Enjoy!

Sources:

https://unix.stackexchange.com/questions/326462/how-do-i-install-atheros-ar9271-wifi-drivers-on-debian