Do any primary historical sources exist which record why these tribes decided to back the Confederacy, in their own words?
This older answer of mine covers a lot of this, so I would expect to be of interest for you.