The Bundesliga and Champions League champions were chasing Hudson-Odoi all summer but were ultimately unable to sign the youngster