When someone has been diagnosed with Stage 5 Kidney disease then it means that the kidney's have lost the ability to function correctly and yes it can be fatal and terminal if the person doesn't have a Kidney Transplant or get on dialysis treatment.
If they have a Kidney Transplant or dialysis treatment then they have a good chance of living a normal lifespan.