My impression was always that the term connoted one who was wearing an ass as a hat, i.e. has their "head up their/an(?) ass". Which as many would already know is an English idiom connoting someone of poor manners.