Tail Asymptotics for the Limiting Distribution of Theta Sums