You note in your other thread that you’re full-pay. As a parent, I personally wouldn’t be looking to keep paying close to $50K per semester for my kid to have the experience you’re describing, for the sake of an art degree they’re not even sure they still want.
Keep in mind that you do not have to stay in college continuously. It is completely fine to take some time off and regroup! In fact, that is a better approach than rushing into a hastily-chosen Plan B just to get out of Plan A.
NYU might be the best transfer plan, or it might not. Having an amazing time as a visitor doesn’t necessarily prove that you’d find it to be the perfect place to be a student. Explore your options; there are many! You have some excellent ideas about potential majors and career plans; keep researching that and considering what you’d like to do.
Since you like kids and are considering something education-related, you might consider applying to City Year, and doing that while you’re exploring your options and applying. The website says they’re accepting applications for mid-year starts… and they have a program in NYC. So it might be possible to be near your friends in the city this spring, rather than dropping another 50K on spring semester at CMU, do something career-related, and give yourself time to make well-considered choices about your next steps. Just a thought.
Or, for less than you’re spending on CMU, you could do a spring semester abroad (though you’d have to move quickly) through a program that accepts students directly, such as Parsons Paris - priority deadline to apply for spring is Oct 15.