As he releases his candid memoir, The Lightning Seeds frontman shares his complicated thoughts on the football anthem, and how grief over his brother's suicide changed his life for ever