We tried a few plugins for this but after content reached 400-500 pages and about 1500 blog articles  the plugins just run out of memory. Instead we built and used this function, for example, to remove all shortcodes used for “citiations”. We no longer track citiations and want them all removed.

update wp_posts set post_content = replace(post_content, '[citation id="1]', '');