Tooth decay requires several parameters
1- bacteria
2- bacteria food source
3- acidic environment
4- time
We all have the bacteria but the other ones are somewhat controllable. What many people don’t account for is the 4th parameter of contact time.
It would be better (for your teeth, not overall health) to rapidly drink several sodas than periodically sip one for several hours.
Decay typically only occurs in a pH environment of 5.5 or lower, otherwise the enamel is resistant to the acid. So the longer the pH is lower the more likely you will develop a cavity.