Four people, including two young children, have been hospitalised following a gas explosion at a popular NSW holiday park.