Do I need ECC RAM for a retro gaming server?

No. Emulators are CPU-bound, not memory-error-prone. A flipped bit in a texture or sound sample would cause a tiny glitch you’d never notice in a retro game. ECC costs more, can be slower, and requires workstation hardware that doesn’t make sense for this use case. Put the money into a better CPU or more storage instead.