Order-Optimal Error Bounds for Noisy Kernel-Based Bayesian Quadrature