Please, have a look at https://tex.stackexchange.com/a/602822/5735 . I haven’t delved much into the csquotescode, but I'd say it's doing something similar to
\begin{quotation}
\begin{otherlanguage*}{hebrew}
...
\end{otherlanguage*}
\end{quotation}
which is much like \begin{quotation}\foreignlanguage{hebrew}{...}\end{quotation}. This changes the text direction, but not the paragraph one.