Hi Kassy, and
to ATP. So glad you found your way here.
Chelle is correct, once a rosette blooms it will die, but hopefully will leave behind some offset to carry on. The last photo does look like a viable offset. Just leave it sitting on top of the soil, it will get nutrients from the leaf or stalk until it grows it's own root system.
The first photo does look like it has been over watered. The last photo also looks a bit wet. Let it dry out a bit, them mist until just the top of the soil is moistened. Hopefully the little guy will take off growing.
I see the roots growing on the stem. I would leave the stem in the pot, it might still send out some offsets for you.
The long/weird growth looks like the plant is etiolated, meaning it may not be getting enough light.