Those affected will get jobs restocking supermarket shelves or as security guards during the night. If they can't find such jobs, they will make far more noise in their RV during normal sleeping hours than they would if they were sleeping, disturbing the surrounding neighborhood more.

> The hours you are talking about are night hours.

They have some overlap, but night hours generally begin before 9pm and end before 6am. But, in any case, it is possible to sleep during non-night hours. It may be less desirable, but banning sleeping in vehicles in residential parking spaces in night hours is different than banning sleeping in vehicles in residential areas which in turn is different than banning sleeping in vehicles.

What if the person has a job during the day and needs to sleep at night?

Then they are clearly not able to use on-street vehicular camping in a residential area under the law.

That doesn't make the law equivalent to a blanket ban on vehicular camping, or even a blanket ban on such camping in residential areas.