As long as you know the odds are not great, I think it’s great that you want to try. You will benefit from trying, whether or not you end up at Cornell. Idk why people are giving you such a hard time.
So, here’s what I think you should do:
1)Research each and every college within Cornell and decide which one you want to apply to. Cornell has several colleges (7?), each with it’s separate admissions office, and slightly different acceptance rates (Idk if transfer rates are different by college though). You’ll want to make sure that you are applying to the college you want because it’s hard to change to another college once you get in.
2) Visit the admissions office of your chosen college, in person, when Covid is under control. Ask to meet with an AO and ask them the questions you are asking here. I think most parents here know little about transfer. Cornell’s transfer policy is also different than other Ivies’ because some (3?) of its colleges are partly funded by NY state. AOs are real people, so if they know you, they might be more inclined to help you.
3)Study their policies, acceptance rates, “guaranteed transfers” they’ve already offered, etc. and see if there is an “easier” path (i.e. college/major that accepts more transfers).
Good luck, OP. Just remember, Cornell is not the be all end all. With a positive attitude, you’ll go far.