chore: renovate downstream regardless of schedule, add manual trigger

Created by: bobheadxi

As title. Allows us to set a schedule to stop cloud renovate from causing a lot of noise alongside manual renovate.

We are opting for a custom renovate trigger to help reduce ambiguity and improve visibility