Aw that sucks! If the card is recognized by Debian but you can't see networks or connect, you may be able to get away with just replacing the antennae instead of the entire NIC. Cursory glance says those are MHF4 Antenna, but I could be wrong. You would want to look for MHF4 for M.2/NGFF since that's the form factor of your NIC.