Personally I wouldn't put foam on the roof, the whole idea of roof rack / bars is to transfer the load away from centre to the sides of the roof where the strength is. Putting foam on the roof may spread the load but most of load will press on middle part of roof and may well bend the roof reinforcing supports, or break them away from roof altogether.
As Eddie Honda sensibly says, 'get a van'