I work in this field, and I would say anything between 20% and 70% percent of my colleagues believe that useful error corrected qubits will exist in less than 1

I work in this field, and I would say anything between 20% and 70% percent of my colleagues believe that useful error corrected qubits will exist in less than 10 years (depending on what exactly you ask). So I guess the answer is yes, there are respected scientists that would wager that we will have enough useful qubits for interesting chemistry simulations in 10 years.