The last season of Picard managed to turn things around. Yeah it was fan service, but it felt like tasteful fan service (mostly).

I think if he were to get top notch creature effects artists to do practical effects work on the alien world and save the CG stuff for wide shots and space stuff, I think people would respect that.