What does the structure of your scene look like?
With Y-sorting enabled on a parent node (‘A’) but disabled on a child node (‘B’), the child node (‘B’) is sorted but its children (‘C1’, ‘C2’, etc.) render together on the same Y position as the child node (‘B’). This allows you to organize the render order of a scene without changing the scene tree.
I believe your Player needs to be a sibling to the TileMapLayer nodes.
I would refer to this answer: Is it possible to y-sort tilemap scene collection tiles? - #2 by salianifo