Static IP makes network unusable.

Also the RPi4 is using nameservers with private IPs which do not match any IP range of the assigned IP addresses and hence may not be reachable at all. Something is using resolvconf to set them, but wrongly it seems.

However, setting a static IP to rule out the DHCP server being the culprit is the first step.