Ralph Erskine’s Grade II-listed council estate, built to replace the old Byker neighbourhood, is an examplar of design and public participation – and proof that it is rarely in the interests of people to demolish their original homes