I'd say the jury is out and won't be back in.
True, Superman believed it was real, but whether his actions were driven by his own ideas or by Ching's suggestions is an open question. Though it seems like a bit of a no-brainer to me. I mean, Superman accidentally destroying the world? The proof of that particular pudding is in the eating. He's faced opponents at his own level of physical power before and still always managed to be reasonably careful about collateral damage.
He even faced foes even more powerful than he and yes this was in the Sliver Age folks, and still manage not to destroy the Earth in the process. There were a lot of logic and plot holes in that tale, which is why it was re-conned as soon as it was over like it never happen. So the sandman tale goes in the same pile as the infamous "The Master Mesmerizer of Metropolis" even if it is more fondly remembered.