Yes, and that is different to what I said we needed to fully understand what is going on. We need Fast Attitude turned on.
This is the single worst acceleration vibration I have ever seen in any (flying) aircraft.
Your acceleration noise or vibration is 2x your maximum. When on the ground exceeds your maximum and this is why you see the problem. With the faster logging I may be able to get an idea where this is coming from. It may be a higher frequency signal that looks like a low frequency signal due to the slow sample rate.
The VIBE message shows higher frequencies that are difficult to see in the controller logging. Your vibrations appear to be lower in frequency and dominate your controller logging. Due to the low update rate of this logging it is hard to know exactly what the frequency is.
And the key part of my advice is below:
This is being done in the height control, but we also need to restrict the values to the maximum you allow the autopilot to use. Your frame vibration noise is higher than these maximum values.
The real solution is to remove the 1g vibration that you are constantly feeding to the autopilot.