is this like limited time or smth and is this gonna be replacing the original magearna reward for full dex completion?

No expiration date. Magearna is only up to Galar, I think. Meloetta is SV+DLC only.