Brad Arnold, the frontman of rock band 3 Doors Down, has shared heartbreaking news with fans, telling them he is battling stage 4 kidney cancer in a deeply personal video