Creatine metabolizes into creatinine which is major indicator of kidney function because not being able to clear creatinine means your kidneys aren’t working. Adding more creatinine to your system decreases your ability to clear it leading to fatigue, edema, high blood pressure etc.

So it isn’t bad for your kidneys: it is bad for everything else.