URL Redirect Limit

How would we increase the URL redirect limit? If not possible, how would we manage our URL redirects without deleting the existing ones? This is so we can avoid Error 404’s on our website. We are currently running a multivendor marketplace with over 500k products.
We have a Shopify Flow in place that when our resale products inventory goes down to 0, a URL Redirect will be created.

Unfortunately we are getting errors on the Create URL redirect flow stating “Ran into exception: Path is already in use”

Are you certain that the path you are using is not in use as an active product or redirect URL?

That error reads to me like you should try changing the path value but then again it needs to be specific so that the redirect can occur properly when the URL is visited…