The purpose of the SOP is to show the admissions committee why you're the best candidate to offer admissions and funding to. So, should you tell them that you may not be good at it?
I think, telling ur weakness is a show of strength. It says u know what you lack. You could probably add things u are doing to overcome that weakness. It also impresses upon ppl that you are honest and human after all.