pretty much what prism said
it isn't entirely up to Paradox to get mods on Console, it is also up to Sony and Microsoft
to my knowledge, Paradox is "looking into it" but you have to understand that even if Sony and Microsoft give the okay
1) Paradox will have to develop a mod tool/engine for the Console Edition of Stellaris, or tweak the existing mod tool/engine that exists for the Console Editions of Cities Skylines and Surviving Mars to work with the Console Edition of Stellaris
2) Modders will need to take the time to see how the tool/engine works and determine if they want to make a console port version of their mod
3) Likely the mods would need to be hosted by Paradox [which is a layer of approval] and then put forward to Sony and Microsoft [a secondary layer of approval] (see Bethesda and what they did with the console mods for Fallout 4 or Skyrim)
this will all take time; plus given how console jumps patches in such a weird way [with no means of backtracking versions] this means that some mods would possibly be left to rot much like they sometimes do for the PC version; as updates to the game render the mod obsolete or the mod developer decides to no longer support the mod; in either way it makes it so the mod can't be used on future versions
as Psycho stated, it will likely never happen due to the complexities of modding on console and the extra hoops Paradox would need to jump through [not even factoring the modders themselves]