Sri Lanka's opposition says the coalition government must resign, following a heavy defeat in local government elections.