Yes - nearside wing needed to come off and replacement of corroded section should hopefully resolve the issue.
Thanks, Rich
Maybe stick some pics up of the work done already.
Believe me, its not only you suffering this issue. Its so common now on XJ40. its very frustrating, but it is fixable.
i would consider flooding the bulkhead cavity seam with waxoyl/ Dinitrol to help protect it from sitting water. Because its hidden away, its very hard to monitor, as you noted when trying to remove the scuttle cover.
Water can also leak in around the big wiring loom grommet low down on the lower rear section of the front wings.
Its possible your windscreen may be leaking too, since its been removed before, but this is less common on XJ40 (although of course very common on earlier jags.
Another issue thats becoming more common is blocked/ corroded drain hoses on the sun roof (if you have one fitted on your Sov). Water can end up leaking down across the headlining board, down the A post, eventually finding its way into the footwells of course.
Plenty to check then!