It's a lot better than just "source available". You can do most things as if it was open source. The difference between "you can sell it but you have to provide code to anyone you sell it to" and "you can't sell it but you can sell support and development services" is pretty minor.

The two main restrictions on top of that are "no paid API" which also seems pretty minor when the whole intent of this is local operation, and excluding large companies which is pretty low impact.