This is a guide to make newer Intel wifi cards get detected by Debian, to show ip addr show
The clue is to upgrade the kernel and intel firmware.
echo "deb http://deb.debian.org/debian bookworm-backports main contrib non-free non-free-firmware" >> /etc/apt/sources.list
apt get update && apt get upgrade
apt-get install -t bookworm-backports linux-image-amd64 firmware-iwlwifi
apt-get install network-manager
reboot
At time of writing, the kernel upgraded from 6.1 to 6.12 or something
nmcli device wifi list
nmcli device wifi connect "BSSID" password "PASSWORD"
nmcli connection modify "BSSID" connection.autoconnect yes
If you can't ping at this point, disable the ethernet port/interface
ip link set enp1s0 down