TIL: Raspberry Pi 4 can't connect to WPA3 networks

After a few hours of running in circles with

nmcli connection add type wifi con-name foobar ssid foobar

then

nmcli connection modify foobar wifi-sec.key-mgmt sae
nmcli connection modify foobar wifi-sec.psk 12345678
nmcli connection up foobar

and endless

sudo systemctl restart NetworkManager

I have figured out that the Raspberry Pi 4 is not compatible with WPA3 networks. Ordered a compatible USB WiFi adapter and that worked like a charm.