It certainly pays better than being a physician in the socialized medicine system would!
The average neurosurgeon makes over $500,000 per year. Given his qualifications, Gupta could have probably made significantly above this average.
He may well have taken a pay cut when he went to work for CNN, and the Surgeon General job is going to pay even less.