Physical limitations of the Hohenberg–Mermin–Wagner theorem