Longtime weather reporter reveals career-ending diagnosis on-air