I think film at this point is still much greater in terms of resolution compared to digital. I have a Mamiya RB67 Pro-S, and If you take a 6x7cm transparency drum-scanned at 4000dpi (this is the
film grain level, and some drum scanners even go up to 11,000dpi optical res.), you're looking around 9449 x 11,024 pixels. Of course, drum scans can be rather expensive.
A high-end DSLR like the Canon EOS-1Ds Mark II 16MP camera has a Max resolution of 4992 x 3328 pixels. But I do think digital cameras definately win in terms of convenience, like in street photography etc. And many digital camera specific post processing softwares, can really make digital look superior to film.
But seems like everyone is biased when it comes to what they think is best anyway.
Here's some info about film comparison to digital MPs I found on various sites:
Consumer Digital Camera 0.365 megapixels
Amateur 1kX1k " " 1.05 megapixels
Pro 4kX4x " " 16.77 megapixels
35mm fast film 22.11 megapixel equiv.
35mm medium speed film 54 megapixel equiv.
35mm slow speed film 124.76 megapixel equiv.
Ratio'd for medium formats (using actual film sizes e.g., 56mmx56mm for 6x6cm..):
area ratio megapixel 16.7megapixel how one 16.7Mp chip
format to 35mm equivalent chip equivalents compares as % film
6x4.5cm 2.9:1 364 Mp 21.7 times 4.6%
6x6cm 3.6:1 453 Mp 27.0 times 3.7%
6x7cm 4.5:1 566 Mp 33.8 times 3%
6x9cm 5.3:1 633 Mp 39.6 times 2.5%
How Many Megapixels To Equal 35mm Film?
"As we've reported in the past and have deduced from our own tests, a tripod mounted, high end SLR with a superb lens and ISO 100 color print film can capture the equivalent of a 40 megapixel sensor. That's an order of magnitude more than a 3.3 or even 4MP sensor..." - Popular Photography, March 2001, page 55.
AFIPs Peer Reviewed Science Paper (see table)
35mm fast film (ISO 400 and up) = 22.11 megapixel equiv.
35mm medium speed film (ISO 100 to 200) = 54 megapixel equiv.
35mm slow speed film (circa ISO 25-80) = 124.76 megapixel equiv.