No real surprise that Kodachrome was the first to go -- the process for it is seriously gnarly, and not shared by any other film, so it took a lot of infrastructure to process it. Your corner one-hour photo lab couldn't do a thing with it. Other films like Ektachrome are still in use.
News photographers were among the first to switch over. For them, fast, cheap and good enough trumps slow, expensive and perfect. The first event the AP shot in all digital was Super Bowl XXX, in 1996 (yes, I had to google that).
Glossy magazine covers were another matter. Depending on the film used, and how you define the comparison of analog grain to pixels, 35mm is roughly equivalent to 15-20 megapixels, a threshold that took digital cameras a while to reach.
Film is still useful for things like disposable cameras, but we're getting to the point where only artists will be interested in it.