An analytic approach to stochastic Volterra equations with completely monotone kernels