real(::SparseMatrixCSC) should not be deprecated

[dlfivefifty]

This behaviour is inconsistent with real(::Array), which is not deprecated (per discussion in #20387)

julia> a = speye(Complex128,10,10);

julia> real(a)
WARNING: real(A::SparseMatrixCSC) is deprecated, use real.(A) instead.

[fredrikekre]

Ref #19242 where conj got un-deprecated for the same reason.

[stevengj]

Looks like a bug in #17265, cc @Sacha0

[Sacha0]

Bug indeed, good catch! :)