Certified GKH Gardening Expert
That plant was intended to be very short lived. The container is far too shallow, the tips are painted, and it is in need of many things.
First, I would put that into a standard container. A cactus and succulent mix with a little compost will be perfect for soil. They do not like to remain wet, and will tolerate drought very well.
This with proper care should fix all of the issues for quite awhile, until it needs repotting with fresh soil for nutrients.
All tubular types have the same care. This article will help you to grow tubular Sansevieria: https://www.gardeningknowhow.com/houseplants/snake-plant/starfish-sansevieria-care.htm