Again, the low rankings in things like "business friendliness" and "cost of doing business" are mainly the result of intentional choice in California to be highly protective of consumers. California has more consumer-protection regulations than anyone. It's those sorts of regulations that drove, say, Elon Musk to relocate to Texas, where he could pay his workers less and didn't have to worry about running afoul of state regulations that were meant to protect them from being exploited by bosses like Musk. That may make the state less attractive to businesses but doesn't mean the state is making the wrong policy choice to be highly protective of consumers and workers.
Also, FWIW: in 2019, when Newsom was elected governor, the same CNBC rankings ranked California 32nd in its overall business friendliness rankings:
So, if you're going to, for whatever reason, use those rankings as the end-all, be-all for how good a job the governor is doing, seems like he deserves credit for improving California's lie.