Name should be the name of the song
Artists should be the singer
Only when you're looking at a list of FILES. You're not in that screenshot, you're looking at a list of ARTISTS.
That's why there's only each artist listed once.
I can tell, because of this:
When viewing Categories by Details, the Name column shows the name of the currently selected Category. It isn't showing the [Name] field contents, that's a special column that is shown when you view Categories in Details mode. That's so that the currently chosen Category field is
always visible, no matter what Column Layout you've chosen.
And because otherwise, the "real" [Name] column wouldn't ever work right, as it would always just show [Varies] unless you only have a single track by a particular artist.