Cynthia Nixon reveals why this Sex and the City scene left her “devastated”