I was in the same camp until a few months ago. I now think they're valid tools, like compilers. Not in the sense that everyone compares them (compilers made asm development a minuscule niche of development).

But in the sense that even today many people don't use compilers or static analysis tools. But that world is slowly shrinking.

Same for LLMs, the non LLM world will probably shrink.

You might be able to have a long and successful career without touching them for code development. Personally I'd rather check them out since tools are just tools.