"A very few worthies have been allowed to overcome the spell, in desperate hours."
Superman being one of the few, he was worthy enough to overcome the spell in time of need and Thor knew that which is why he gave him the hammer. The fact that Superman couldn't lift it anymore is because there was no need for him to use it anymore.