Even if you run a "full" Linux distribution as opposed to a specialised virtualisation/containerisation distribution like Proxmox, host resource usage will be small.
As far as I'm aware (i.e. not very aware at all), Proxmox doesn't have a plugin architecture. So it boils down to flexibility against ease of use.
Another option would be containerisation on your current CentOS install which would result in even lower "guest" resource usage, but that of course depends on using containerised applications.
Depends on whether you want to learn about Linux and the open source world, or just use it.
Not sure what the release cycle is like for Proxmox, but the RHEL kernel/Debian OS combination just doesn't sit right with me, but not for any particular reason (I'm just like things to be simple). CentOS is a good base IMO. That said, I live in the command line and don't like these complete packages.