To dream of an acrobat represents an aspect of yourself that is maintaining balance under chaotic conditions. You may have a lot of pressure or demands being put on you. An acrobat may be a sign that you need to ask for some help or may benefit from a slower pace. It may also be a sign that your creativity is being stretched too thin.
Alternatively, dreaming of acrobatics may be a metaphor for sexual intercourse.