The answer to your question depends on your definition of weight. A
common definition, is that weight is the force on the object resulting
from local acceleration/gravity as measured by a scale.
With that definition, an astronaut satellised around the earth is
weightless as gravitation is balanced by the acceleration it causes (if you accelerate without gravity, the force due to inertia, measurable as weight, is in the direction opposite to the acceleration). Actually,
the same is true if he is not satellised and is just accelerating
towards the planet (physically the same situation, though the
astronaut might disagree).
Your weight on a planet will depend on the gravity on the surface of
that planet (and a little bit on rotation speed), or in any internal
part that you can reach.
What is implicit there, is that somehow you need to define the scale
used to mesure the weight. On a planet the scale can be anchored to
the planet spot where you are measuring weight. In space, you can
reasonably anchor it only to something following the same trajectory at the same time,
and you will mesure zero in free fall (not quite actually if there are tidal
effects), which is what was happening to our astronaut, in both cases.
Hence, I am not sure what weight of the earth would mean. Where is it
measured and under what conditions. Essentially I would reach your
first conclusion and say that, like the astronaut, Earth is weightless,
Now you could also want to define weight as just the force resulting
from gravity produced by a nearby body, by somehow considering that
you are at rest with respect to that body. You still have to know
exactly where, so as to determine gravitational acceleration.
Then you can compute the weight of the earth with respect to the sun,
at a distance corresponding to the earth orbit. This gives of course
a different result, depending on the mass of the planet as you know
and noticed.
You are then ignoring the sun rotation, though rotation is taken into account (however small the effect) if you measure weight at the surface of a planet.
This is the reason why the relevant physical concept is mass rather
than weight. The distinction of mass and weight was a major progress
in physics.
Note that the first and the second definitions of weight will not give
you exactly the same weight for a person at the surface of the
planet. What is measured by your bathroom scale is the first, which helps a little bit feeling in shape. Earth rotates.