When someone "is there to support" you, it means that they are willing to help you. It also means that they are able to help you.

I'm there to support you, son. Whatever you need, just ask.

The kind of help or "support" that a person gives can be monetary support, which means that they will pay for you. Another kind of support is emotional support, which means that they will listen to your problems and give helpful advice.