the plane pretty much has to pivot about its CoG
Sorry to be pedantic, but there's no such thing as a fixed CoG in an aircraft.
It's why weight and balance calculations are so important in order to ensure your proposed CoG is within an acceptable range.