Add support for Pip 24.2 / statically linked musl libc CPythons

[jsirois]

Although #2017 will be resolved by a patch to Pex's vendored Pip (See pex-tool/pip#13), no modern Pip until 24.2 will support this. When adding support, update tests with a reference to this issue.