The redirect behavior in SXA only applies to sites managed by SXA.
Consider the options typical of a non-SXA implementation but be aware of the risks and limitations of each.
Redirect in CDN/Proxy - difficult to apply for many 1-to-1. Cloudflare for example limits the number of available page rules.
IIS Rewrite module - Low complexity for large ...
For performance wise IIS redirect are good. Some references for Sitecore redirects: