Adds a note to clarify that `while_preventing_writes` is not meant to be
a replacement for a readonly replica user.

Closes #39132 and #39133
Co-authored-by: NEike Send <eike.send@gmail.com>