I once grew a pineapple in a pot. It survived its first zone 9 winter outdoors, did not survive the 2nd. It was in a big pot so not easy to move around. This time around I will plant in a smaller/lighter pot so I can overwinter.
I would suggest a very sandy soil and bright light for growing pineapples indoors. Also, you don't need to use more than about a 1 gal size clay pot (or plastic pot with some rocks in the bottom for stabilization). Like most bromeliads, pineapple plants have a very limited root system - generally just enough roots to hold the plant in the soil.
Thanks for the photo of your pineapple crown! To get the best results, you may want to strip off most of the small, brown leaves to expose any "primordia" (small root tips) that are often present under the brown leaves.