I know how horrible the feeling is to not get the school you want.
Been there, done that. DD got into our third (of 3) choice school 4 years ago. I was gutted. Cried and cried. We live 6 mins walk from the preferred school. A mile from the one we got. First school had good ofsted. Third choice, satisfactory (with a pretty crappy reputation).
But you know what? I love love love the school she's in. It has been brilliant. So lovely. Reputation completely unwarranted. Superior grounds, fields, settling in process, attitude to reading schemes, SATS refusing.
While I hear lots of positives about the first school from the many people I know with kids there, I also hear negatives. Things that I'd have concerns about. And there are aspects of dd (and now ds1's) school that aren't amazing, in the main and in general it is the right school for her. She has thrived there.
The journey - well lots of people walk further. I had a buggy board for dd to ride on when she first started. Then she scooted. Then ds1 got bigger and he scooted. And now if I walk (sometimes I do drive if I've places to be straight after) ds2 is in pram and ds1 and dd walk/scoot.
I don't know the school you've been allocated. But I just wanted to say that I've gone from crying and bemoaning dd missing out, and not knowing anyone at new school, and feeling like the poor relation, to feeling very satisfied and happy with the school she was given.
I didn't appeal in the end. There really were no grounds upon which to appeal.
We were on the waiting list for the first year, just in case. Went from 17th, to 3rd, to 10th, to about 8th as people moved into the area, closer to the school. But you may be much higher up the list. The 60 child reception list went as far as the third child on the waiting list by the time school started.