I suspect a lot of the slowness is due to the DISTINCT on AUDIT_DATA.
It might be worth working your way through the following article by Paul White as well as the referenced articles. Some of the ideas will only work with SQL2019 but you should be able to get some improvement with other versions of SQL.