Mangione also earned a firm position as a pop culture icon of sorts, to the point he memorably played himself on the beloved animated series King of the Hill