Generally you use some kind of tool to manage/update the mods and set them to load in the right order. While those tools may also work under Linux with Proton/Wine/etc, each app you launch typically has its own isolated folders. So in order to get it to work, you'd need to change where that mod manager app uses to use the folders that Proton/etc configured for the actual game like Skyrim. That's compared to just installing the mod configurator/launcher app and having it start Skyrim for you on Windows.

The fact that there's a 60 page guide on how to do it tells you it's not as easy as on Windows: https://www.nexusmods.com/skyrimspecialedition/mods/91500?tab=description

They can use any number of extra libraries and such. Idk I'm not a programmer. But I've certainly tried. Though tbh it's been. A while. Sadly I dual boot just for the games that I mod that require a bunch of external tools to mod. I don't have the time anymore to try and force em. A me problem yes.