Learn German: Die Pflegekraft bietet uns großartige Unterstützung.

You could swap the positive adjective großartige for an absolute comparative like größere to say Die Pflegekraft bietet uns größere Unterstützung. In this context, größere doesn't literally mean greater than someone else's support, but rather quite substantial or rather large support.

Why does the adjective großartige take an -e ending here?

It is modifying the feminine noun Unterstützung in the accusative case. Because there is no article (like eine or die) in front of it, the adjective takes the strong declension ending -e to indicate the gender and case.

Why is the dative pronoun uns placed before the accusative object großartige Unterstützung?

In German, pronouns prefer to sit as early as possible after the conjugated verb. When you have a pronoun object like uns and a noun object like großartige Unterstützung, the pronoun will almost always come first, regardless of which one is dative or accusative.

Does the feminine article die in die Pflegekraft mean this specific caregiver is a woman?

Not necessarily. Grammatically, the word is always feminine because it ends with the noun die Kraft (the force or power). However, in everyday usage, die Pflegekraft is a completely gender-neutral job title that can refer to any caregiver regardless of their actual gender.