I don’t think you can quantify it in money value, or even if it will open doors on Wall street. The value is in how much you enjoy playing, wanting to be on a team where you’ll make lots of friends, the skills it teaches you. Can you get those opportunities in other ways? Sure. Maybe your freshman roommates mom is a doctor or dad is on the board of a bank. Maybe you get on a research project that opens doors. Being on a team is one way, and a successful way, to open doors but not the only way.
Do you want to use athletics as a hook? I don’t think playing a sport is valuable if you don’t want to do it or if you don’t want to go to that school. Apply to the top schools you want to attend and see if you get in. If you’d be happy going to. your state school, you have little to lose by trying for Brown or another Ivy. without a hook.