You do not "become at the end of your tether". You "are at the end of your tether".
I think in context of the play's structure, no - this is not a good use of the idiom. You could use it when saying that after rejection by his daughters Regan and Goneril, Lear is at the end of his tether = he does not know what to do next.
Student or Learner