Short answer: yes, he needs to sleep. But not for physical restoration, because earth's yellow sun gives him his physical powers, and this also carries him through the night until the sun rises again the next day. He needs to sleep in order to dream, which keeps him mentally/psychologically fit. If you want details, go here.

People also ask similar questions, e.g., Does he need to eat?, etc. This gets complicated, because it depends on what era/age we're talking about in the history of comics (with DC/Action/Superman comics being a sort of "gold standard" for accuracy). During the Bronze Age (roughly before 1959) and Silver Age (roughly 1959-1970) he seemed to get everything he needed from the earth's yellow sun. So he didn't actually need to eat, breathe, etc. Later on he did need to do these things. For more details, go here.

But I'm not so sure that the AoS TV series was always completely faithful to the Bronze Age comic books. E.g., it's unclear whether Superman needed to eat/drink, but he certainly did so on several occasions. However, I suppose one could argue that he enjoyed the taste of food, coffee, etc., but didn't actually need them. Or maybe he occasionally ate/drank in public so as not to seem strange, but maybe didn't do so in private.

Gee, thanks for the info/links. I guess w/all the different "worlds"/eras/ages, things can get confusing.