Rock legend's final days marked by health battles, family support, and one last farewell performance in Birmingham Leer