I haven't read the books, but I get the impression that the vast majority of the city - the poor - support the sparrows. I think Tommen (his advisors) realizes that he doesn't have the forces necessary to route the sparrows and quell the revolt that would ensue. That's just conjecture, but my only explanation for how even Tommen could be this inept.