Yes, people who know ASM are in demand in a tiny very small portion of dev work. And even in most of their main areas like embedded a lot is moving to HLLs these days so even that is leaving but you don't hire asm devs to build your product anymore maybe a feature or something because they are just not productive enough.

When C and C++ came out we had a whole new class of problems too with people not using them correctly and over time best practices developed to make it safer and better quality. The same thing is happening today with LLMs.