No. System Link creates a local area network (LAN) between consoles using Ethernet cables (or a LAN switch/hub). It does not connect to the internet and does not require an Xbox Live Gold subscription.
For modern Xbox consoles (One/Series), online multiplayer via Xbox Live (Game Pass Core) is the only way to play with others.