Tight Bounds on the Laplace Approximation Accuracy in High Dimensions