In some musical cultures it's also totally acceptable and featured all the time, without being considered dissonant.
How many people consider the blues dissonant?
It reminds me of my first counterpoint assignment. "Fourths aren't dissonant" I said, and it came back covered in red marks
To say blues doesnt sound dissonant sounds more like only adding the relative minor b5. Or British blues rock.
And other cultures like tritones just fine, featuring them even more prominently.
There's no inherent "tritones are dissonant" human universal, it's a common practice harmony prejudice.
But the chord function is only one third of the picture. Dominant chords can have greater or lesser tension depending on which extensions are used. A closed voicing will sound more dissonant than an open one.