Never crossed my mind to look for such kind of bulb but I’d risk I won’t be able to find it in the local market.

If safety/security is a concern, lights are simply placed at hard to reach locations or are bought with safety housings, which are fairly cheap. In extremis, instead of common voltage bulbs, high voltage are used, thus incompatible with household voltage.

And specific purpose lamps… I may be the odd one but there are other sockets available in the market. Why opt for the basis threaded one?