Fractional stochastic wave equation driven by a Gaussian noise rough in space