What’s in the pic does not move the sphere, it moves the entire pawn - the sphere happens to be attached, so is the camera, which moves with it all. It’s also not set up all that well as we’re missing a colliding component at the root - although this may be intentional, of course.
The character has a different component setup and the character movement component keeps it stuck to the ground. You’d need to enter flying mode / jump to make it float. The character also has gravity, so it would try to land,
Try to get the Sphere (click and hold the left mouse button on the sphere, then press and hold control and move the reference over to the graph, now unclick the left mouse button) now connect it to the target node in the add movement input.
Hope it works.