Some considerations that might help you decide:
In a typical pier application, deflection is independent of weight. Deflection is the same whether the load is 30# or 300#.
High performance piers are necessarily heavy. No economical way around that. But, there are ways to safely handle a heavy pier without equipment - even with only one person. You only have to move one end at a time.
Clay + water = movement. It's nice to get below the most active surface soils but it's no crisis. It just means you may be touching up PA every now and then.
Multi-section piers can be fine if you use enough bolts in the connection so that the pieces can be considered bonded and therefore a single unit after assembly. The down side is cost. Each section cost about the same as a whole pier due to fabrication of additional plates.
Multi-piece piers can be fine but there is little weight savings for the same performance and the cost is very much higher. Connection design is different, as well as some other things, but it can certainly be done.
The ATS tripod has a small foot radius so instead of 3 independent footings, you could enlarge the pier cap a bit and catch all 3 legs on one foundation.
Tripods are an excellent structural shape but we introduce problems when we make them portable. Stiffness is sacrificed for lighter weight (aluminum is 3x more flexible than steel) and in all the hinges and connections for folding can be sources of arcsec deflection.
Another option is to use the tripod since you already have it and see if it meets your needs. Tighten all the joints or put them in a bind so that it is no longer collapsible to try to take out any wiggle. If that works for you, you can attach the legs to the foundation with some clip angles.
No need to be concerned about resonance. Everything vibrates. Even the back of your eye has a resonant frequency. A telescope pier has not one but several modal frequencies. Fundamental frequency corresponding to first modal shape is called natural frequency of the system. Increasing stiffness increases the natural frequency. Increasing the mass decreases the natural frequency. An increase in the damping diminishes the peak response but broadens the response range. What does this mean to a properly designed telescope pier? Absolutely Nothing! Since the magnitude of the vibration is less than the deflection, less than the camera can detect, it doesn’t matter if it’s vibrating at 40 Hz, 400 Hz, or 4,000 Hz.