i can vouch for that rotty!
It's a shame, isn't it; sorry to hear that.

there is a document called a SODA (Statement of Demonstrated Ability) that will allow color blind pilots to fly. Depending on the severity of the color blindness it could be listed as a "mild color dificiency".
To obtain a SODA you basically go out on the ramp and the tower sends 3 or 4 light gun signals your way and if you get them right they give you the SODA and remove the night flying restriction. I have heard of a few pilots with very mild cases of color deficiency making careers out of flying so its not impossible. I say follow a career in flying and seek a business degree or something of that sort.
good luck
Doesn't the SODA also apply to many other deficiencies as well, like handicapped pilots flying specially-fitted aircraft or one-eyed pilots?
I think the thing that grounds most pilots in their prime is heart trouble, but I could be wrong about that.