As you’ve discovered there is no provably “right” answer. One thing I noticed, though, is you mention money a few times. If your parents can afford to send you to your current school and you’re taking out little or no loans that’s one thing, but if your parents are taking out loans and you’re maxing out on your student loans then I’d say you should transfer. If money isn’t a deciding factor then it’s harder to say but I think you should transfer. It sounds like dance is really important to you and this gives you a chance to continue to pursue it.
If you transfer maybe you’ll end up in a dance career, maybe in marketing for dance companies, maybe in marketing for organizations involved in the arts, maybe in marketing in something completely different. And yet even then life can have funny twists. Years back there was a poster on the forum, @molliebatmit, who in one post talked about how her achievements in science had been helped by her love of cheerleading. Among several ways she credits it as helping was as an EC that stood out when she applied to MIT, and later after she applied for an internship they brought her in to meet because the interviewer was curious what a MIT cheerleader would be like. So you never know how dance might lead to a connection!