Please explain what bit rot is. First time hearing this.
It's one class of UREs (unrecoverable read errors). If you write your data, then read it back right then to verify, and all is fine, but then reading back the same data fails
after it's been sitting for some time, that's bit rot.
A good write to a good platter surface should last quite a long time--maybe decades--before it's a concern. However, writes that are just barely readable by ECC, not well-centered or otherwise well-aligned on the track, written to weak sectors (sectors that are usable enough to keep from being marked bad, but just barely), or from some other scenarios I'm not aware of, may not be so lucky. Many, if not most, HDDs, could go their entire usable lives without encountering a single such problem. But, having seen it myself, it can and does happen.
On the plus side, generally good backup/recovery methods for generalized UREs will also cover bit rot, should you encounter it, so it's not worth worrying overly much about, as specific class of failures. Archives with checksums, and file systems with checkums, can detect it,
and much more common data loss/corruption cases, equally well.
Optical writable media suffers from bit rot as a failure mode almost exclusively, assuming decent media.