Switch to newer open/close issue workflow

[haydentherapper]

Description

We redesigned the open and close issue workflows in https://github.com/sigstore/community/tree/main/actions, we should switch to these.