Cooling foam is an oxymoron. No cooling foam actually cools. Foam is an insulator by design and all the cooling chemistry does is to make it easier to absorb your body heat. As the heat generated by two sleepers exceeds that of a 150 watt lightbulb the foam will quickly become the warmest thing in your room. A big deal is made of air circulation and some foams, notably latex, have cellular structures that allow for more airflow than a dense memory foam. Unfortunately the difference is not enough to dissipate the incoming heat and as heat rises most of circulated air will be drawn up through the mattress to keep reheating your sleeping environment. The dense nature of the foam also conducts heat directly through the top surface adding to the problem. No cooling mechanism will do more than briefly cool the surface of an unoccupied bed and all will reradiate heat that builds up throughout the night.
One solution to overheating is mechanical heat removal, at the low end Bed Jet is a simplistic ducted fan that blows air at your feet while elaborate contraptions with hundreds of feet of water filled tubing and refrigerated chiller pods are available for $6000 plus accessories. Another solution and the one that I personally buy into is to make a mattress without foam. This was the norm for hundreds of years before foam came along. Materials like wool, cotton and linen were the premium materials used in a product that was made to last a lifetime. Most of that brand that currently offer mattresses made exclusively with these materials are either extremely expensive, or excessively simplistic and lacking comfort.