Most beekeepers won't even see CCD in their hives.
Beekeeping is just like any other hobby or vocation that involves living things. There are diseases and pests that can be an irritation or a scourge. Tomato blight, fleas, kennel cough, hip dysplasia, fin rot, just to name a few from a few of my experiences in other realms of hobbies.
Varroa and tracheal mites, killer bees, were going to be the end of beekeeping as we know it, but hobby beekeeping is still largely the same as it was with a few changes. Commercial beekeeping is different, to be sure.
Will you get hit with CCD if you start? Who knows. I haven't and I don't think that most here have. It is scarey and all over the news, but I think it is still a small portion of hives that got it.
Like Jerry said, it seems to be more for the commercial beeks. Don't let it stop you any more than fin rot would stop you from getting aquarium fish or hip dysplasia or kennel cough would stop you from getting a dog. There are ups and downs, euphoria and disappointment in any hobby.
It is helpful to find a mentor or beekeeper that you can talk to and follow around. Then you can see the day to day and get a feel for what is going on. On the news you will get the worst of news, and on these forums there are a lot of people asking for answers to problems, so you probably see the worst of it. It really is a great hobby!!