Yes, we need to capitalize are in a title, if it comes at the start or the end of the title, or even in the middle of the title, as it’s a helping verb and according to title case rules in all major style guides, you should always capitalize every verb or helping verb.
ex:
Correct: "Why Are We Here?"
