As with suspension bridges, when the forces ( usually a road deck) on the rope are high enough that the mass of the rope is negligible, the curve is parabolic. If the children twirl it very fast it will tend to a parabola, slower and stationary, a catenary.