The CDN repos are inted to replace the “old” download URLs in the future. Dependent on you setup (this was broadly explained several times) the relevant openSUSE-repos-Leap and openSUSE-repos-Tumbleweed packages get installed automatically on a users system and the CDN repo URLs get added.
If you have a custom repo list, the mentioned packages won’t get installed automatically. Except you have a Nvidia repo or an unaltered openSUSE repolist (read: original unaltered and named repos)…