Exploring the frontier of quantum computing technology and its transformative impact on computational science