What happens if you rewire a lamp to active ground vs active neutral?

Nothing bad will happen with a simple lamp; it doesn't really care which way electricity is flowing through it. For more advanced electronics, changing poles could have other adverse effects.

Note that this refers to the lamp alone. Also make sure the armature you are placing the lamp inside does not give you surprises from connecting your active ground to things you don't want it to.