With the introduction of 6f461ea592ca, some of the workflows were not
prepared to handle concurrency for "push" events so we had to add the
group for these type of events.

Also, some of the workflows were not running the "commit-status-final"
as this step was only running for events that were not type "push". As
the list of required workflows are based on the name created by this
step, we also need to run this step for the "push" events. Some existing
workflows already push "commit-status-final" for pushes as well so the
introduction for these workflows will be consistent with existing ones.

Finally, the push events should only be triggered for pushes done
respective to the "main" branch, thus we will be using the prefix
"renovate/main-**" instead of "renovate/**" to avoid triggering the GH
main workflows from stable branches and vice-versa.

Fixes: 6f461ea592ca ("run CI automatically for renovate")
Signed-off-by: André Martins <andre@cilium.io>