There is a known bug/feature (depends on who you ask) that if you order by a field that is not available it doesn’t do logical NULLS first nor NULLS last, but rather NO NULLS.
Let me go find a linked article about this if I remember.
Here it is: Expected behaviour for sort queries
So it was agreed upon to “fix” this, but I still don’t think it was fixed yet.