Old, no internships and not going to a top 20 school. Should I change paths?

I (27m) am going back to college (Baruch College) with the intention of studying finance.

I have 7 years of management in hospitality and I don’t want to do it anymore. I want to study and transition into finance, I do have a passion for it and I am used to long grueling days.

With that said, coming here and reading makes me think it’s not the best idea and I’ll be stuck with opportunities.

Is it smarter to avoid finance and find something with different standards that I have a chance in?