Exclude filter getting all items where relation dosen't have item with attribute Name X

Also, could you outline your expectations with the second query (in plain english devoid of the technical aspects) as well as what is currently happening