My experience is a lot like @drspouse in terms of the paperwork etc for adoption is NOTHING like the paperwork for school.
My advice is trust nothing, and no one- question question question.
Read the CPR, and look through with a fine tooth comb. Mum used drugs but gave up when pregnant? Find out exactly how many weeks she was when she said that, was their screening at birth, any alcohol? Don't take any vague answers, you need specifics. Were parents in mainstream school throughout childhood? Any SEN at all?
Read the CPR and imagine it's you, and that everything that could be spun against you ever, has been. Imagine you were dealing with shifting sands of expectation, instructions that differed between staff, all sorts of different and conflicting advice, being treated as the enemy, imagine how that might actually explain some birth parent behaviour. Because after years of dealing with the authorities trying to get education and support for my LOs, dealing with gaslighting, lies, little power trips, sheer incompetence, and underfunding... I can totally see why BD stormed out of a meeting telling them all to fuck themselves. I have been close.
Honestly, approval is the easy part. Matching is hard, and you need to be utterly ruthless about what you can manage, and not fall in love.
Then you fall in love.
And you'll walk through anything for them.
But be aware dealing with the local authority might be like trying to make sense of the clouds.
If you can, get everything in a post adoption support plan. Those I know who have done better than us either adopted an older child, with more 'known' and obvious needs that could be planned for and support sorted pre order, or have been 'fussy' and not considered even a whiff of alcohol, drugs, SEN etc. You still get trauma, of course.
Of course, the child is worth it. But if you can question question question, and trust nothing that isn't written in a support plan, you'll be in a better position than most.