The following command is required to set the MAC address for a wireless interface for a given wireless network profile (which is named after the corresponding SSID) to the permanent address.
This is in response to a change introduced in Fedora 40 as documented in the Fedora Wiki: Changes/StableSSIDMACAddress
nmcli connection modify {ssid} wifi.cloned-mac-address permanent