I've done a few Tech DDs on companies who have very CRUD-like operations and oddly chose to CQRS. Mind you, these are software companies doing about $3~$10M in revenue after 10 or so years (i.e. not rapid growth, but still valuable).
Honestly, my big question is...why? I can find thousands (millions?) of CRUD and MVC developers in pretty much any major language, but how many developers can I find to write CQRS based code?
The answer is in your question. Because event sourcing is a niche skill, devs see it like playing on a higher level of a computer game.
But where it’s really needed, nobody would choose a novice. So novices learn to do event sourcing on systems that don’t need it, and proceed to make a huge mess. Most companies don’t have any kind of architecture review to prevent this happening - they have managers who naively trust the developers.
Honestly, my big question is...why? I can find thousands (millions?) of CRUD and MVC developers in pretty much any major language, but how many developers can I find to write CQRS based code?