I totally appreciate the sentiment around SSPL being not open-source but honestly, we don't know what is an alternative. We want to build an open-source product but also build a commercial entity around it – which means we want to stop the cloud providers from offering this as a service.
We explored a couple of alternatives. AGPL does provide a similar level of protection against cloud providers – any app talking to RudderStack over an API to send events would be forced to open-source the app and hence it is almost not possible to build a SaaS service on top. But for this exact same reason, our users don’t like AGPL. AGPL is considered an absolute NO in lot of enterprises. To get around this, we have also thought of releasing our binary (and AMI images, docker images) under MIT license so that people can still run it but then but that was getting too complicated for a licensing model plus this doesn't stop AWS from offering it as a service. As you pointed out, Apache with Common Clause, CockroachDB license are all alternatives but none are true open-source.
We are just hoping that one of the big OSS guys (with the budget to pay the attorneys) will figure this shit out once for all and we can just follow.