Before an acrobat flew through the air, the word described someone walking very carefully on the tips of their toes.
The Greek adjective akrobatos meant "walking on tiptoe." It joins two pieces. Akros means "at the farthest extreme" or "topmost," and -batos comes from bainein, "to walk" or "to go." The image is of a person raised up as high as their feet allow.
In later Greek the word became a noun, akrobates, and the meaning narrowed to a tightrope walker. That is a natural step. Someone crossing a rope high above a crowd is walking at the top, and doing it on the balls of the feet.
French took the Greek word as acrobate. Dictionary.com notes that the French form may be a recoinage, a scholarly revival of the Greek, rather than a word passed down through centuries of use. English borrowed it from French. Merriam-Webster's earliest evidence is from 1827, while Dictionary.com places the first record a little earlier, between 1815 and 1825.
The performers themselves are far older than the word. Merriam-Webster traces ropedancing back to the ancient Greeks, and English had "ropedancer" from the early 1600s. "Tumbler" for someone who does tumbling feats goes back to the 1300s.
The word arrived just before a burst of new circus vocabulary. In 1859 Jules Léotard invented the flying trapeze, and the close-fitting garment he wore became the leotard. The noun "acrobacy" appeared by 1867, about twenty years before "acrobatics." By 1883 the naturalist John Burroughs could call the essayist Charles Lamb a "verbal acrobat," a figurative use that is still common.
The akros half has a large family in English. It is the "acro-" in acrophobia, the fear of heights, and in acropolis, the "highest city" of an ancient Greek town. It even sits inside acronym, a word that names something by the tops, or first letters, of other words.