You'll only get condensation if you have warm moist air - exactly what are you really hoping to use it for? (as if we didn't know).
I think this is misleading, as its suggests an unheated container will not form condensation, which from experience is not true.
You will need a vapour barrier on the inside of the insulation.
Sprayfoam is something like 90% closed cell, so its not really an issue.
I have a uninsulated metal garage, and the form condensation (and in the right weather, a good amount of rain!) which I put down to the fact that of an evening the air outside is colder than the ground and therefore air inside. Water runs in under the door, forms puddles, these evaporate and the form condensation.
Your proberbly getting the same in the container, I presume there just placed on the ground? They have woodern floors, which are proberbly fairly soft/damp if there secondhand containers. Raising them up on bricks to get air flow under might help, but I would be temped to install some large vents to get some good airflow through there, not just messing about vents, you want to open it up and get flow through even on a still day. I cant see the spray foam doing any harm, and it might help, but I would got for decent vents first, and covering the more valuable/sensitive items in polythene.
But I dont know the proper solution, and havent had chance to do any testing with my garage.
Daniel