If I do the door supervisor course would I only be limited to working in nightclubs and pubs?

No, this is a general misconception that door supervisors only work at night clubs and pubs. In fact, door supervisors can work at a site where a normal security guard is required. Please see the list of places above where a door supervisor may work.