Are mechanical drive resistant to bit flips?
No, but they don't lose charge over time, so bitflips are less likely if they lay around for a long time. However they are less resistant to mechanical failures, so it's kind of a trade-off.
If you use a sane backup software it should be able to just overwrite all the data making bitflips hardly relevant.