Is CF a superior form of memory? If all the manufacturers use them in all their models above entry level there has to be a reason for it! Why are they better?
There are probably several reasons why higher-end cameras use CF cards vs SD cards.
1. Legacy. If you're a professional photographer with a higher-end camera, you've probably been using CF cards for many many years. So your camera bag is likely full of CF cards. Although memory is pretty cheap these days, switching from a stack-full of CF cards to a stack-full of SD cards isn't an insignificant expense.
On the other hand, someone who's buying an entry-level dSLR probably hasn't made a prior huge investment in CF cards. And if they've had a point-and-shoot camera in the past, they might already have SD cards lying around. For these reasons, it's okay for an entry-level dSLR to use SD cards.
2. More rugged. CF cards are larger (the size of a matchbook) and are pretty rugged. SD cards are smaller (the size of a postage stamp) and feel less rugged. To me, I feel like I can bend and break an SD card pretty easily. I can also lose an SD card pretty easily too. If I stuck an SD card in a pocket, it's easy for me to overlook during a "patdown" right before laundry time.
CF cards feel more firm & rugged and can take quite a beating. They're also easier to find during the pre-laundry patdown.

Or, if I'm shooting and want to switch memory cards, I can find my spare CF card easier in my pocket and probably less likely to lose compared to a tiny SD card. If you're shooting for an assignment or as a profession, you can't afford to lose your memory card.
3. CF cards have faster maximum speeds. I'm not sure if you'll notice this in regular day-to-day shooting, but CF cards can go as fast as 600x (90 MB/sec advertised, 30-50 MB/sec in real life). I use 300x CF cards (45MB/sec advertised, 23-35 MB/sec in real life). If your camera can take advantage of these faster speeds, then it's an advantage when you shoot in burst mode, like for sports photography.
I believe Lexar's & SanDisk's fastest SD cards are 133x (15 MB/sec advertised speed).
4. SD cards keep changing. Remember owning an SD card (not SDHC)? The maximum size of those SD cards was 2GB or 4GB. And then SDHC cards came out, and their maximum size is 32GB. Unfortunately, you can't use these SDHC cards with your older cameras because those cameras won't recognize SDHC. And a new version of SD cards is becoming more commonplace: the SDXC. Will your camera today recognize tomorrow's SDXC cards?
CF cards are and have been pretty standard. The CF cards you buy today actually work in yesterday's cameras.
I think these are some of the major (and minor) reasons that higher-level cameras continue to use CF cards. Of course, I'm no expert in memory cards, so please correct me if I'm wrong.