ci: allow renovate approve on minor, patch and digest upgrades

[fcanovai]

Enabling the automerge configuration will allow the renovate approve bot to approve PRs opened by Renovate, while still requiring CodeOwner approval.