Can of course, if the guys at Valve like the mod. But as you recognized correctly, this is highly unlikely to happen with GE: S,
because of those rights and now with these CoD 'GoldenEye' games out in the open it's even more unlikely than it was before.
Pirates Viking and Knights II is listed as well in Free Mods, but there won't be any special advertisement beyond that. And if I remember correctly, even Desura wouldn't distribute GE: S.