A Queensland has fronted a NSW court after he allegedly shot at police during a pursuit in Sydney's south-west on New Year's Eve.