Sex, death and the American car industry in art icon Barney’s latest work