Vanishing nematic order beyond the pseudogap phase in overdoped cuprate superconductors