How can it be used at all under SSPL then? There are no operating systems on which Redis runs that uses that license.
In essence, the license says you cannot use it as SASS software, but they didn't want to outright say that, so they did this instead.
So yes, this basically prohibits anyone but redis from operating it as a service, unless you write your own operating system for it to run on. (Although presumably they will sell you licences or similar to operate it as a service)