I agree with @bbeliveau about the useful limit being within a few microns inside the tissue, as well as spherical aberration being the limiting factor by degrading the PSF. This of course will depend on the tissue type and sample preparation.
Classical STORM has been performed on brain slices in the first microns (classic example is Dani et al. Neuron 2010, see also some tips and tricks in Barna et al. Nature Protcols 2016). Various tricks have been published on the imaging and algorithm side (see Bon et al. Nat Meth 2018, Mlodzianoski et al. Nat Meth 2018, Li… Ries Biomed Opt Express 2019 for some examples), which could help in getting a bit deeper.