You need to make sure that you are connected to the internet to download the mods.
These are the steps you would need to follow to install mods on your consoles (PlayStation 4, Xbox One):
You can, in this section, explore a massive number of mods. Therefore, when in the Mods tab, you will see all the mods available on your platform, the ones you own and the ones you can download and install to play on. The process of installing mods on consoles is identical, but installing mods on consoles can sometimes not turn what you would expect, or they might as well end up crashing your system. You can access the mods section by clicking on the “MODS” button in the main menu. How to Install Mods on Fallout 4 on Consoles