Space–time discontinuous Galerkin approximation of acoustic waves with point singularities