'I’ve always said I’m going to go until the wheels come off. And they finally have fallen off', says tearful 3-time Super Bowl winner after knee injury ends his storied career