The former Blackburn Rovers manager was suddenly diagnosed with bowel cancer earlier this year