Water pouring into the vehicle is a real b*tch... I've had the same issue on my old Explorer. I resealed all the roof racks, bolts, windshield gasket, etc... and still water would pour in directly over the overhead console. But only sometimes, as some rain storms it was dry as a bone. It was driving me f*****g nuts!
As for Expeditions, a car evaluator I spoke to recently told me that the Expedition bodies are built to different specs at the factory depending on the trim, with the SSV being the lowest spec of them all (my model). Apparently the SSV's have poor undercarriage welds and are notorious for water / debris infiltration. Mine has sand and dust in the rear quarter panels where the fuel pump reset switch is, indicating this to be true. I haven't seen any water on the floor, though.
So, it is possible that the Ford factory took some SSV bodies they had lying around to build other trims, resulting in the water infiltration some people here seem to have...?
Anywho, this is also the reason why I refuse to own a vehicle with a sunroof : 1 part of actual use for 10 parts of trouble!