Knowing CS allows you to build unique solutions from first principles. In cases where you're tied to applying solutions that have already been decided there will be less opportunity to use your CS knowledge. I think the majority of the time for most jobs you're just applying solutions, so it's much clearer how this would benefit you professionally.

Depending on the kind of work you do, the minority of the time where it would be beneficial to know CS might have a big impact both on the product and your reputation in the company. This could help you move up to higher, better paid positions, but it also might not. Teaching yourself CS is a big time investment and if you just want to maximize your salary there's probably better ways to do it.

I think it's really only worth it if on some level you enjoy it and find it interesting. You can seek out jobs where they use more CS, but again this doesn't guarantee you'll advance professionally. But if you're the type of person who enjoys programming as a creative activity, I think CS can be very rewarding because it opens you up to what's possible.