I am running several Archlinux Servers since 2013 in an production environment and it works like a charm.
Sure you have to make sure that updates are going well by running them often and to always check the archlinux page before you upgrade.
But thats it, in the end you will have much more troubles upgrading RedHat/CentOS from 6 to 7 (almost impossible) or SLES/SLED from 11 to 12 and so on.
You have constantly small updates that, from time to time, cause some action but i never had something big in the last 5 years.
And also you are always up to date, if there is a security leak in the kernel, in openssl, in the bash or whatever, you have the updates in a few hours rather than days to months.
My Server for example is fully upgraded and protected against spectre v1, spectre v2 and meltdown, i am pretty sure that only 1% of the people posting here have servers protected against all three.
Its fast, its secure, its stable(!) and you have current software which reliefs you from a lot of issues.
I can highly recommend using Archlinux on Server, only downside is that you have to know what you do. You should have installed an LFS system at least once so you understand the very basics on how a Linux distro is built and works.
The only Server System i found more rock solid than Archlinux in a Server Environment was Gentoo. There was one Gentoo System without updates for 700days and 1 hour later this system was up to date and running with the only down-time being a single reboot.
But other Systems like Debian/Ubuntu, RedHat, SUSE will just screw you up completely when there is a distro upgrade. RedHat even actively discourages you to do an distro upgrade and recommend to reinstall (according to the official documentation).
So yes, RedHat is more upgrade stable than Archlinux, but only because you dont get big upgrades. And when you get them, you are screwed.