Yes drinking too much soda can eventually lead to kidney disease and kidney failure.
It's best to not drink soda at all but if you do drink soda you should only drink a little bit as in one or two cans or bottles of soda per week or no more than one soda per day.
Soda is very bad for your health and kidneys and I now avoid drinking any soda at all.
Too keep your kidneys healthy you should drink, water, tea, fruit juice and other healthy drinks but avoid too much soda even though it taste good, drinking too much soda can shorten your life due to kidney failure and kidney disease.