I think most audiences enjoy the character trope that is the deadpan snarker. It's common in all branches of fiction. Shaw In Picard exists as a kind of soft antagonist though. We aren't supposed to side with him as it's his function to stand in opposition to the heroes. He's a Jellico in other words.
Do I enjoy Shaw in PIC? Yes, absolutely. Do I want to see a spin-off show about a grumpy, racist Captain who turns tail at the first sign of danger? No, not really.
Do I enjoy Shaw in PIC? Yes, absolutely. Do I want to see a spin-off show about a grumpy, racist Captain who turns tail at the first sign of danger? No, not really.