It's not that big of a deal.
Really. On the list of things to worry about in your web or software development, I'd place "worrying about how colorblind people see my website" pretty darn near the bottom.
Here's a comprehensive list of the ways that my disability has caused me to suffer:
* I'm really awful at picking strawberries and cherries. Dark red fruit against green foliage does not stand out at all to me the way it seems to for other people. Before she knew I was colorblind, my mother just thought I was lazy and/or eating all the fruit I was supposed to be picking.
* Occasionally, I'll buy/wear clothes that don't match. Because I think they're brown, but really they're a subtle shade of green.
* Sometimes, I'll call something brown or grey or blue that's really red or green, and people will find it hilarious.
* When people learn that I'm colorblind, they spend several minutes pointing at things and saying, "Can you see that? What color is it?".
Really, that's about it.
I vary rarely come across things on my computer screen where the functionality is impeded by my inability to distinguish color. Though, I've got to admit, the BBC's football table example is a pretty great example: http://wearecolorblind.com/example/bbc-online-football-table...
I suspect that things are different for people with different levels of colorblindness, but then you're talking about ~1% or less of the population.