Adding Solid behavior to an object won't prevent it from going through other solid objects. Solid is mostly used to work with other behaviors like Platform, 8-diection or Line of Sight.
It won't be an easy task to make the movement like in Deepest sword. One solution is to create an animation where the character is rotated around the sword. Stop the animation when the character's feet (an image point) touches the ground.
Another way to do this is to change the point of rotation. Instead of rotating the sword around its handle, when the sword touches the ground, you unpin it from the character and start rotating the sword around its tip.
Like I said, it won't be easy. I suggest you start by studying a few example games included in Construct 3.