Dazzling Aerial Feats Unraveling Acrobatics A Comprehensive Review