When Bruce wayneWayne returns as Batman in Dark Knight risesRises he isn't the same person onin terms of his responsesreaction times and agility which he possessed years ago when he decided to hang up his boots at the end of Dark knightKnight (plus the limping at the start of the movie) . Alfred strongly believes that he is also inferior in physicality, strength and reaction to Bane when he sees all those footagesthe footage of him during the Motorcyclemotorcycle chase scene he enacts in front of Gotham.
Alfred tries to explain the scenario to Bruce wayneWayne to the extent of Bane's strength and also believes that Bruce wayneWayne is trying to be batman to satisfy his obsession, even though he is old Bruce wayneWayne still has the heart of the old batman and tries to counter him stating that his weakness can be exploited which ultimately leads Alfred to leave on the fact of their heated discussion.
All those years Alfred never gave up on Bruce because he believed that he could fight those odds in reality but in the case of Bane the age alfred, Alfred instinctively knew that this was the fight Batman can never win at that point of time given his strength and also earlier Alfred hints to him (the coffee place he talks about) about starting a family (or finding the right girl) which could'vecould have led him to that decision.
(Rightly so alfredAlfred is correct at that point and Bruce wayneWayne gets his broken back immediately after he leaves)