Is it possible to get a purely VFR job with colour blindness?
There is another test, called the Farnsworth Lantern test, which you can take.  Not many aviation medical examiners have the lantern, so you might have to ask around, but if they have it and you can pass with that, you meet the medical criteria.

The waiver that Terry discusses is the SODA (or statement of demonstrated ability).  I had to get one for nearsightedness when I got my Class I, which consisted of a trip to the local flight standards office, a checkride with the FAA inspector who agreed I could fly just fine with my fully corrected 20/15 but uncorrected >20/200 vision.  There are plenty of airline pilots floating around with waivers of this type.