Is Tate no Yuusha light novel finished?

Is Tate no Yuusha light novel finished?

In the end, the choice is yours. The Light Novel is still ongoing, but already quite a bit ahead of both the Anime and the Manga.

Why is Shield Hero hated?

Perhaps past Shield Heroes have also had the bad luck with diplomacy that the current one is having, aggravating the situation. This leads to the elites hating the Shield Hero, whereas the general public doesn't seem to have anything against him besides the rape allegations.