This paper focuses on investigating the stochastic Volterra integral equations (SVIEs) with double weakly singular kernels. Our primary objective is to examine the well-posedness of the proposed equation. Specifically, we explore the presence of existence, uniqueness, boundedness, and the continuous dependence of the exact solution on the initial data. Additionally, we develop a stochastic θ-scheme as a numerical solution for the equation and demonstrate that the convergence rate of the scheme is influenced by the kernel parameters. To validate the accuracy and reliability of our theoretical findings, we present two numerical examples. Notably, one of these examples concentrates on estimating the price of a European call option using the Heston stochastic volatility model with a singular kernel. Our results, when compared to the corresponding findings by Li et al. [3], not only relax the integrable limitations of singular kernels but also establish a precise convergence order. In addition, we propose an improved scheme, based on the efficient sum-of-exponentials (SOE) approximation, to address the low computational efficiency of the stochastic θ-scheme. The results confirm that our approach aligns significantly with the expected physical interpretations.