There’s not much difference in “prestige" between CMU and NYU in your fields of interest.
You sound miserable - CMU is a “fit school” and choosing it just for perceived prestige when you’re not growing as you feel you ought to, means you need a school that’s better for _you_ and where you will grow, hence ensuring you benefit from college both academically/artistically and personally.
What’s your college GPA? Would you be able to afford an apartment in NYC (I don’t think transfers get college housing)? What major would you be applying to at NYU? Please note you would likely not get any merit aid from NYU so the matter of affordability is essential.
You could also apply to the U/x major within CALS at Cornell (bargain price for a NYS resident).
Apply to transfer (Spring 2026? Fall 2026?) to a few universities. *If* you get into a few, you’ll be able to make a decision. Applying doesn’t mean you have to transfer. Getting in doesn’t mean you have to transfer. Applying only means you give yourself that option if you get in.