I would not worry about the 1DsMkII failing to provide improved resolution when used with appropriate lenses, meaning good primes and excellent zooms, since surely that is what one would use if seeking even more resolution that the 1DsMkII provides and paying $8,000 for the opportunity.
But then again, the resolution increase will only be about a modest one eighth (12.5%), since that is the increase in linear pixel density. That seems mostly in the realm of "slightly more cropping latitude while still meeting my client's rigid requirement of 300ppi uninterpolated for a double page spread". (At 300ppi, the change is from 11.1"x16.64" to 12.48"x18.72".)
Even with lower pixel count DSLRs and film of less than the maximum available resolution, there are noticeable differences in sharpness and resolution between different lenses, so to some extent, resolution is already "partially lens limited" (except perhaps with the sharpest available lens.) And yet when one upgrades from those cameras to a higher resolution film or sensor, overall resolution is seen to improve with many lenses. This is because, as has been mentioned, even when the lens partly limits resolution, so does the "sensor", so improving either with improve the overall result.
Sensor resolution improvements would only fail to improve overall resolution if the lens limits were dominant, so that very little resolution could be gained by improving the sensor. I do not believe that the 1DsMkII is near that point, at least with good primes and excellent zoom lenses, though the wide angles seem to be closest to this problem. And look at some lenses that Canon has offered recently: new versions of the 14/2.8 and 16-35/2.8L.