The unlikely pair delivered a dynamic and dramatic rendition of Collins' 1980 smash, "In the Air Tonight"