Both Red Hat (AlmaLinux or Rocky) and Ubuntu have very long support windows, so you're good with either from that point of view. I've found Red Hat variants to be a bit better from the point of view of stability, and a larger amount of hosting support, but frankly you'll not go wrong with either...