I put foam under all my tanks. I have a 75G set up for 2 years. The stand sagged a bit in the center and the foam did exactly as planned; it compressed about 50% on the ends and stayed about 90% in the middle.
The key is using the correct type and density foam. On my two large tanks, I calculated the weight for every inch of bottom frame (tank weight, water weight, & X lbs of gravel & rock). Then I cut a piece of wood an inch long and the same width as the plastic trim on the bottom of the tank. The weight per inch was around 7 -10lbs. I placed matching weight over the wood to test the compression of different foams. If your foam is too stiff, it will be no different than placing the tank on a hard surface. You need it to compress a little when the tank is first filled. My foam compressed about 10-20% at first. Worse case, if the stand is twisted corner to corner, the foam will adjust and distribute the weight as if the stand was perfectly square.