The high end cameras are still using them - the D4, D800 use them, and they're fully current. For smaller or slower systems, SD cards are less expensive and possibly more mechanically reliable. CF is about played out, so don't expect to see too many more of them. XQD, I guess, or something else, will be the future at the high end, and various forms of SD for everything else.
_____ Brian... a bicoastal Nikonian and Team Member
My gallery is online. Comments and critique welcomed any time!