It'll only affect 32bit systems with ancient operating systems storing dates in epoch time.
Not a small number. But nowhere remotely near what Y2K could have been.
Hopefully by the time we need to account for a 64bit rollover, I'll be comfortably retired. But by that time, proton decay may be a more worrisome problem.
I used to think that I wanted to distro hop. Turns out that what I wanted was a bare bones OS that gave me the freedom to rice in strange and unnatural ways.
After 25(!) years of battling X11, dependency hells, and the early days of desktop compositing, I finally realized that what I wanted was Arch, and a few window managers to play with. SwayWM, and now Hyprland.
Unless you have some niche needs (real-time audio encoding) or want to play with more esoteric experiments (Nix, OSTree, etc), distro hopping is overkill.
But most distros have homogenized to the point to where all you need is knowledge about systemd to go from one to the other.
Just pick your favorite, non-snap distro and hack on it.