I mean, short answer is that of course they're absolutely useful if you sit behind security firewalls. Is that not enough?
There are also other reasons to host LLM's locally. That is systems that leverage contextual reasoning power of LLMs, but are unable to readily access the internet. A planetary rover (e.g. Mars), for example.