What should I realistically expect from a mattress?

You can expect fewer dramatic temperature swings, less overheating around pressure points, and a generally more stable sleep temperature, especially when paired with appropriate bedding and room conditions. You should not expect a mattress to feel ice-cold all night or to fully offset an overheated or very cold bedroom on its own.