That is a question where the answer is difficult because there are a lot of variables involved to really complicate the matter. Generally speaking, yes, you will end up with far more megapixels than any digital camera output currently. However, that doesn't mean the quality of what you see in print or on screen will be better, especially when viewing compressed JPG's on this site. When your original scanned image is 200meg in file size and you're posting a downsized 200K (200,000) file sized JPG to this site, you have thrown out 90% of your pixels so what good did all those pixels do you? All those thrown out pixels are great for printing in large sizes and for commercial printing purposes but for display on the net they're worthless.
One variable to consider is the resolution of your scanner. If you scan the negative you will end up with far more megapixels at 5400ppi than 2900ppi or 4000ppi. A scan of the negative will equate to something similar to a slide scan in terms of resolution. You will get more detail at higher ppi's but that can be bad detail like noise along with good detail.
If you scan the print, the resolution also depends on the size of the print you are scanning. Obviously a flatbed scan of an 8x10" print will yield far more megapixels at the same dpi/ppi than a scan of a 3x5" print. However, scanning a print is scanning a reproduction from the negative and you are at the mercy of whoever made the print from the negative in the first place.
I haven't scanned recently but I have a scanned (5400ppi) image from a Kodachrome slide of the Aeca Carga CL
-44 belly landing that I recently posted and it is 7065 pixels wide by 4702 high - those two numbers multiplied come out to 33.2 megapixels. However I can't remember if I cropped it first or not.
View Large View Medium
Photo © Don Boyd