The US Navy has apologized for a pilot who spent some of his free time drawing a giant dong in the sky.