Foam, regardless of how dense it is will never be made heavy enough to block sound from transferring from room to room. Soundproofing foam does not offer any decoupling, meaning vibrations will continue to travel through the wall and through the foam. Soundproofing foam should really be called sound absorption foam.