While a lens can be a limiting factor w.r.t. the ability to resolve fine detail, there's also a physics problem that can't be overcome.
You want to learn about "diffraction limited photography":
Diffraction Limited Photography: Pixel Size, Aperture and Airy Disks
Due to the 'wave' nature of light (it doesn't travel in a straight beam... it's a wave), the ability to resolve fine detail is related to the physical diameter of the lens (larger is better). This puts limits on the level of detail that any lens can possibly resolve.
The limits were originally discovered by astronomers (George Airy gets the credit for working out the details), who wanted to keep increasing the magnification of the objects they were studying, only to discover that while reasonable levels of magnification did make objects larger, there's a point where you get into unreasonable magnification where the object does get larger... but it also gets blurrier... and you ultimately can't see any more detail by increasing magnification.
As an amateur astronomer, one of my telescopes is fairly large... having a 14" aperture. I'm often asked by guests if they would be able to see the flag on the moon. Never mind that flag... I point out that you can't even see the moon buggy (lunar rover). The rover is roughly 3 meters long. But that's much too small to be seen from Earth... by
any telescope in existence.
The math is described in a simple equation called "Dawes' Limit" (see:
Dawes' limit - Wikipedia ) and when you do the math, you find that a telescope would need to have an aperture roughly 25 meters in diameter to be able to resolve detail as small as a 3 meter object located about 384000 km away. The largest telescopes on Earth are currently just barely larger than 10 meters in diameter.
If you read that first article I linked above, what it will describe is that the light from a single point on a subject does not land on a single point on your sensor. It lands in some "area" due to it's wave nature. If that area can land entirely within the boundaries of a single pixel, great. If not... then the light is landing on an area that overlaps several pixels so it doesn't matter that you have "more" pixels, you will not be able to get a sharper image unless you have a significantly larger physical aperture diameter.