Find and Replace is something that you really need when you need it. And the ‘when’ of when you need it is when you move your WordPress site to a new domain or server.
When you do that you will almost certainly need to run a search and replace on the database. The reason is that there will be links that are no longer correct. For example, if you have a link on a page or post that refers to a location on your old domain.
There are a couple of plugins that do Find and Replace. There’s Better Search And Replace, of which there’s also a pro version with added features. And there’s Search Regex made by John Godley, who also makes the Redirection plugin (which is excellent) and who works at Automattic.
Automattic is the company that owns the community version of WordPress and is the principal trustee for the version from which stand-alone WordPress sites are made.