On my Laptop with an identical Fedora setup (Fedora 40 KDE Spin, Kernel 6.10.11-200.fc40.x86_64) this worked without any problems. However, on my PC this same certificate file throws:
pk12util: PKCS12 decode not verified: SEC_ERROR_BAD_EXPORT_ALGORITHM: Required algorithm is not allowed.
pk12util: no nickname for cert in PKCS12 file.
pk12util: using nickname: ###REDACTED###
pk12util: PKCS12 decode import bags failed: SEC_ERROR_BAD_EXPORT_ALGORITHM: Required algorithm is not allowed.
I have already checked update-crypto-policies to be at DEFAULT
Interesting, but AFAIK Fedora 40 still accepts SHA1 without any problems. It worked on my laptop. Anyway, thanks @vgaetera I just extracted the key and certificate chain and converted it to something more modern: