chore(ci): remove closed-issue and opened-pr workflows (#7047)

chore(ci): remove closed-issue and opened-pr workflows (#7047) #3938