In 1966-1967 when I delivered mail as a Wayne State University political science student in Detroit, I said to one of my many black friends "How can Stevie Wonder say it's implied to be a good thing to have things uptight, when people say to each other uptight means tense or upset? Like I'm so uptight when my father starts in on his lectures I feel like I just have to split.
He said his friend also used it as settled and completed as fine." I was going to lend my buddy money anyway so when he asked I told him hey, it's uptight. Don't worry about it."
James Brown used it in Out of Sight in 1964, too.
https://soulfuldetroit.com/showthread.php?21918-The-Way-Stevie-Used-The-Word-quot-UPTIGHT-quot
Now, in 2020, the above woman say it's making her "tight" as a really bad thing, y'all know?
Like Jimmie Walker, as JJ in Good Times would say “that’s BAD!” meaning it’s cool, or good.