Russia is a vast country, but as a former local (north-west region) I'd say that it's generally not a good idea to drink tap water there. I haven't talked much about water quality intentionally, but I believe everyone I know holds a similar opinion, and doesn't drink unboiled tap water.
It could be "safe" in a sense that one probably won't get sick from occasionally drinking it, but anecdotally - in comparison to bottled water, tap water is of questionable quality just about everywhere in Russia.
Unless we talk about separate kitchen taps with reverse osmosis systems. Even then, most people I know, don't drink that water directly but only use that to fill the kettle for boiling.