Some folks seem to think that a raw score is the most important thing. It’s not. An applicant is compared to other applicants. 790 is 79th percentile. While a different animal, 79th percentile on the Math SAT is 620. Is 620 and 800 close enough, that someone should be mocked for wanting to retake a 620?
OP, what majors and schools are you looking at? If STEM at MIT, Caltech, Harvey Mudd, and maybe one or two others, I’d say it may be worth another shot if you think an 800 is realistic. When there are thousands of Math2 800s, a 790 is different. At most other schools it’s fine.