feat: add support for additional cosign media types

When searching through failed migrations that are part of gitlab#350920 (closed), I noticed that we're missing support for one cosign media type:

application/vnd.dsse.envelope.v1+json

https://github.com/sigstore/cosign/blob/main/specs/ATTESTATION_SPEC.md