I understand what you mean. With Redis and many other database/cloud companies switching to source-available licenses, maybe the term source-available doesn't have to have such negative connotations. Open-source is also divided in permissive and copyleft licenses (e.g. BSD and GPL), both have big implications on how it can be used.

Redis and others see themselves forced to switch to a more restrictive license because of the big cloud providers, who sell services for others software, without contributing back. This change is not good, but it might be necessary. Just like GPL is more restrictive than MIT, but it's necessary to force some company to actually give back instead of only taking.

I personally don't really dislike licenses which allow for the necessary freedoms of open-source after one or two years. It's a compromise but secures the longevity of software beyond a companies success. It's way better than proprietary code.