Currently, AT&T is still using it, and the US Gov't is in the process of converting their CF into .Net (Federal Reserve Bank and US Navy). I still see some CF pages from time to time; matter of fact, I just applied for a job with an organization that is still using it, so wish me luck. I still love CF, probably always will.
One of the great features of CFML is that the language is so easy to learn. At times, it's almost like an extension of HTML. Plus, since it runs on Java, you have access to all of the power of Java.
Its built in integration to things like Exchange Server, LDAP, Java, ORM and SharePoint integration are some of ColdFusion's main appeals to the larger Enterprise market. I once heard an Adobe rep. jokingly say that it was easier to use CF to connect to Exhchange Server than it was with .Net.