It is reasonably common in all of the London boroughs unfortunately. I'm sorry you didn't get a school higher up your list.
But the good news is that waiting list moment is also very common. Make sure you are on the waiting lists of all 5 schools you missed out on. In the coming weeks, other parents will e rejecting their places to move house / go private / Home Ed and that will create vacancies at lots of schools which are filled by offering the places to people on the waiting list who missed out in the original allocations.
Lists are kept in order of admissions criteria (i.e. if you live closer you will normally be nearer the top of the list) and they keep moving usually all summer. They are left open until Christmas at least. So, whilst it is disappointing at this stage, there's still a long time to go and you might yet get offered a school you said you liked more.