The term "blew it" can mean that someone failed at something. "Blew it" can also be taken in the literal sense, meaning someone expelled air through their lips into or through something. A trumpet is an instrument that only produces sound if air is blown into it. The joke is playing on the phrase "blew it" while referring to a trumpet player. 
He auditioned for a part as a trumpet player but he blew it .