Shots have been fired on a popular beach strip in southern Sydney, terrifying locals and sparking a major police operation.