Sorry but you're not going to get "in detail" simply because the details would take forever to write.
I've not used Vine but do use RedHat.
Technically RedHat Linux isn't around any more. RedHat was split into separate projects called RedHat Enterprise Linux (RHEL) and Fedora years ago. RHEL requires a paid subscription to use. RedHat is the name of the company rather than the full name of the Distro.
On a quick check it appears Vine was designed for use mainly by a Japanese audience for desktop (vs server systems).
RedHat is a US based company and the main intent of RHEL is for commercial use Many 3rd party applications and databases support RHEL. Such products MAY load on other distros like Vine but you won't get support from their makers unless they specifically say they support Vine. (The other big commercially supported distro is Suse.) RHEL has a long life cycle (they're just now doing end of life on RHEL5 after more than 10 years). RHEL does have both Server and Dekstop versions. Since its focus is commercial they do have versions for other languages such as Japanese.
Most other Linux distros are not quite so long lived so one reason to use RHEL is for stability of platform which is important to many companies. I don't know Vine's lifecycle.
Fedora is free but is "bleeding edge" and typically has 2 releases per year and a life cycle of only a year. It is good for testing the latest greatest. RedHat (the company) supports the project but not individual installations (i.e. no subscription required).
CentOS is a binary compile from RHEL sources so generally will run anything that RHEL will run and has no subscription either. RedHat (the company) took over hosting of CentOS last year so they support the project but again not individual installations. Even though it will run many of the things RHEL will 3rd party vendors typically won't support their wares on CentOS like they will on RHEL.
Last edited by MensaWater; 05-27-2016 at 12:55 PM.