It was a mistake : the 2nd one should have been node -e "require('dns').resolve('repo.yarnpkg.com', console.log)"
The output shows that corepack uses ipv6 with lookup method for dns.
Hope…
PATH=/opt/node_n/n/versions/node/18/bin:/opt/node_n/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
export NODE_OPTIONS="--dns-result-order=ipv4first"
corepack prepare yarn@latest --activate