Terrifying CCTV footage has captured the moment a brazen, deadly drive-by shooting was carried out in Sydney's west.