Increase migrations component memory request/limit to 500Mi/1000Mi

What does this MR do and why?

We still get alerts that the migrations component go over the limit, so this MR should hopefully help.

I also changed the unit from M to Mi, see https://kubernetes.io/docs/concepts/configuration/manage-resources-containers/#meaning-of-memory.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.