Why is WordPress rewriting absolute URLs on staging site to include staging prefix when we manually point them at the live site?

Did you check the two URLs in the wp_options table? That’s where WP gets the base URL for a site.

If you moved the site database from staging to live, you may have forgotten to change those values in the wp_options table.