The reason that mods sometimes disappear on consoles is that if they are updated by the mod creator, they must be re-approved for consoles by the game's developers and the console platforms. Such mods are unavailable while they go through this process again.
Sometimes, mods are also found to have a negative impact on consoles and may be removed or delisted for this reason. You can read more about this process in a useful blog post from the game's developers here - https://forums.focus-home.com/topic/57557/console-mods-requirements