What does supporting an alternative frontend in an instance actually entail?

Because people have different tastes. Be glad you have choices.

Edit: It is not complicated. Setting up Tesseract for my instance was very easy (one new podman container and a change in the caddy config). Some instances might offer less frontend options most likely because hosting something costs money and requires extra maintenance so they don't want to host something that they think people won't use.