For this to even make sense, they would need to also add support for creating/adding cutscenes and voice acting. Having now dungeons filled only with monsters, where the story is solely told by dialogues and/or lorebooks would be jarring. The problem is, that even if they do this, there is no modder or group of modders who will have resources to pull off cinematics and voiceovers on the level of original BG3. And even if we do get modded cutscenes, these will be screaming "mod content" (and people will be complaining anyway to someone).
That's why I think this mod support will be focused on gameplay features and/or UI, not on adding now story content. But we'll see, Larian proved they can reach high, so who knows what they are cooking for us.