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.

Google just announced they plan to have a million qubits in less than 10 years. They’ve not yet demonstrated the ability to go past 100.