Bottom line: Octograbber is dead weight ballast that lowers the Falcon9 center of gravity. No rare earth magnets, suction cups or Velcro are needed.
Dry mass of Falcon9 1st stage is 25,600kg. About 5000kg of this is the 9 Merlin engines and the landing legs. This would put the center of mass roughly 1/3 up the vertical length.
The Octagrabber is very heavily built. This photo shows the base plate about 10cm thick, assuming the road tires are 1 meter in diameter (some of the thickness is I-beam flange).
The area of the Octagrabber is about 150 m^2, assuming the figure in the photo is 180cm tall
If we model the Octagrabber as a 10cm thick steel plate with an area of 150m^2, and a density of 7.7 tons/m^2, that gives a mass of 120,000 kg. Clamped to the Falcon9, this gives a low enough CM the assembly ain't going nowhere.
of course, this is a estimate. But it is in line with the load capacity of the pneumatic tires on the dolly. 18 pairs of tandem wheels with 500lb capacity per inch of tread width gives 160,000kg capacity for that dolly.
Point is, the designers of Octograbber can lower the CM of the assembly as low as they desire with enough dumb steel. It only needs to keep Falcon9 vertical until the crew comes aboard and chains it to the hard points on the deck