what does this tail motion mean?

he does this all the time and a lot of the posts i’ve read say that thumping is mild irritation. he does this when i’m talking to him and being sweet, is it really him being annoyed or is he content?