If I am not mistaken, the ASP .net core is for Active Server Pages only, which is used for websites. There should be another .net core package.
Also you only need the runtime, the SDK of .NET 6 works too but its much bigger and bloated compared to a runtime. SDK stands for Software Development Kit and is only needed if you want to develop your own software (hence the name )
Try the .NET Desktop Runtime 6.0.15 from here https://dotnet.microsoft.com/en-us/download/dotnet/6.0