Is a thing where DSLs are expected to be for non-programmers? I mean language is right there in the name. They are programming languages and you have to have programming skills to use them.

Unless by non-programmer you mean non-developer. People for which programming is secondary or tangential activity. Like scientists.