Frustrated charge order and cooperative distortions in ScV6Sn6