I went with this option. I do not regret a thing and indeed feel a bit smug sometimes when the parents who wouldn't dream of just trying it are moaning about their ridiculous journeys and tiredness and the stress they go through in yr 10 and 11 when they have sleepovers and they don't know anyone and are miles away.
If other people go there and do well then yours can too. If other parents not dissimilar to you have dc there then they will also feel like you about attendance, behaviour, paying for trips etc.
I would support and encourage your dc to join in, sign up for clubs, put themselves forward for sports/choir/chess/library/school council etc. Say yes to all the trips and workshops and concerts and plays.
You can support and augment any gaps at home and with tutors if needed. Keep going with clubs, sports and hobbies outside school. Your dc.will have more time for extras if they're not travelling miles for different schools.
My dc have had a great time, tops sets, friends like them, done DofE, concerts, plays etc and been independent getting there, always had local friends and also developed skills in resilience and making good choices if exposed to poor behaviour and some staff changes etc.
Interestingly, our RI undersubscribed school is now really popular and Ofsted Good. I always thought it was good!