Local roads branded “national embarrassment” as Govt urged to tackle £15bn repair backlog