Did you try to set the pi address in the pi itself ? The networking in bookworm has changed from dhcpcd to network manager, maybe you can check the settings?
To acces them you have to issue the following command
sudo nmtui
That will lead you to a gui where you can edit setting for both ipv4 and ipv6 and for wired and wireless connections.
Maybe the network adapter is connecting via ipv6 dhcp where you are expecting ipv4 static?