Quantum-centric supercomputing for materials science: A perspective on challenges and future directions