From there you can download to your console (provided you have a ID). Just hit up the official site and filter by your platform of choice.
If you need a quick refresh on how to get skyrim mods, it's fairly easy. Then at the end of 2021, the 10th anniversary edition brings the best Skyrim mods to the current generation, as well as brand-new content to PS5 and Xbox Series X/S. The Special Edition landed on consoles and PC and finally brought mods to both PS4 and Xbox One.