At least they named it core and standard so you know which mess you're referring to.
With Apple TV you have to make up your own qualifiers.
Apple's marketing team seems to failing at their jobs right now. They had iPhone had X/Xr/Xs/Xs Max at some point, and I never figure out which was which. The most recent 11/11 pro/11 pro max makes a lot more sense, but it sounds dated.
.Net Core and Standard are two of the best things Microsoft has done in the past 5 years and part of the reason why .Net is doing so well and is super popular.
.NET Core is the best thing Microsoft did even if it sucks they basically redid .NET Framework. It sucks when companies do that kind of thing but the end result is a much more powerful .NET ecosystem. The confusing bit is old .NET Framework libraries that may or may not work at all with .NET Core.