I support this 100%
Looking at other games with modding support, you can see how important that is to let the game thrive over a long period of time.
As the most famous examples I would say Skyrim and the Paradox Games like Stellaris.

Of course they are more mainstream than Distant Worlds 2 but I ...