"I feel really frustrated. I can and would give this child everything possible to feel safe emotionally and materially. They just seem hooked up on this random thing. "
And that might be that you can't fit working in, until the child is five. So, if you would do everything, then there isn't an issue.
They aren't hooked on a random thing. They are working on there being attachment issues and other physiological disorders. It may also come out that there are physical disabilities.
We now have the babies removed from Addicted Mothers, who are now Adults. There are greater numbers of that group, than the general population, who have Personality Disorders etc. research has shown that those that are given to a full time consistent Care Givers, have better outcomes.
We are learning all the time what works and what we could do better. When I worked in Services, it was generally twelve months, to be then reviewed.
Speaking to you about the possibility that you may have to be unemployed for four plus years, just makes the Adoption less likely to fail. Many adoptions do fail, especially as issues emerge.
There is nothing that you can give the child, materially, that will benefit them, if the emotional side is not handled as it needs to be. You say that you know how to access support, there are some issues that can't be fully supported, you can only get support for you, whilst you are dealing with them.
I know you want to do this, but I would really think about the effect on your Children. What also worries me is your Friend turning up at yours once the child has been removed and the fallout from that.