Tight Last-Iterate Convergence of the Extragradient Method for Constrained Monotone Variational Inequalities