Route specific traffic via remote gateway over IPsec

Scenario:
I have some restrictions from Site1 in accessing a particular server(Server1)
Site2 has no restrictions in accessing Server1. I have a site-to-site vpn established over IP, as well as a road warrior VPN setup with Site2 as the target.

From a PC in Site1, I can connect as a road warrior and then access Server1. This routes all traffic and is very slow, so is only used when required. Seeing as this is the only way to access Server1 from Site1 network it makes sense to try route the traffic from local network at Site1 to Server1 via Site2

This is where I have come undone
Not sure if I should use a route or nat rule at Site1 and what changes are needed at Site2

Site1=192.168.25.0/24
Site2=192.168.100.0/24
Server1=8.8.8.8