First of all, film is just as susceptible to resolution as digital cameras are, though it is governed by film speed and film size, as opposed to megapixels. Albeit the average 35mm film is as high a resolution as many semi-professional digital cameras, film has it's own pixel, which is called film grain. If you blow up film picture, you will of course not spot any pixels, they don't exist, but you will spot the grain of the film, which is just as unpleasant as spotting the pixels.
It also depends highly on the speed of the film. with an ISO (also called film speed) 100 film, you can blow up to a much larger size without seeing the grain, than with a film with an ISO of 1600. you blow up a 1600 ISO 35mm negative to an 8x10, and you'll see grain, but for the average 6mp digital camera picture, you can easily blow it up to an 8x10, without seeing the pixels. You'd also see this kind of noise by raising the ISO in a digital camera, so once again, there are many variables.
All of these factors contribute significantly to the "resolution" of pictures, be it from a film or a digital camera. Not to be disrespectful, though your "comments are simple", they address an issue which cannot be addressed that simply. Indeed, film can easily have a higher resolution than a digital camera, again depending on it's film speed. If you were to take a picture at a normal film speed, say 200 or 400 with an 8x10 view camera.... there would be no consumer digital camera that could possibly match the resolution of that picture. Although view cameras are expensive, an average one is $4500 (US) (http://www.bhphotovideo.com/bnh/controller/home?O=productlist&A=details&Q=&sku=63768&is=REG&addedTroughType=search)
their resolution surpasses comparably priced digital cameras many times.
So the answer to the main subject of the post, is... film will have its uses for years to come, though someday it will be come defunct, as image sensors become more and more advance, requiring less power, and therefore generating less noise. Sigma cameras utilize Foveon's X3 chip, which has each color registered on a different layer of the sensor. This allows the sensor's pixels to be larger, and they therefore need less power, and generate less noise. Perhaps this will the be the future of high-quality digital imaging. We'll just have to wait and see.