Your treatment is known as HDR Boost, a very good treatment for high risk T2 or T3 disease. I also had this treatment, 23 fractions (sessions) of external beam and 1 fraction of HDR Brachy. You seem to be having 2 fractions of HDR brachy - different hospitals do have different protocols. Mine did 2 fractions of HDR when it's being used as a monotherapy (without the external beam), in which case they do one late afternoon and the other the following morning, and you have to remain on your back in bed in between with the tubes in place. Even for my treatment, I had to lay still from about 9am when the brachytherapy tubes were inserted, until about 5pm when the brachy treatment was done, which included some trips to MRI and CT scanners to record accurately where the tubes were. This was not too onerous. It wasn't painful, although I could feel it (minor discomfort) and they did offer pain killers if necessary. I had paracetomol when the tubes were inserted (with anesthetic), and another paracetomol around mid afternoon. They gave me co codamol to take home, but I never needed it.
A treatment option I had was to include the pelvic lymph nodes in the external beam treatment, or not. There was no evidence of cancer in them, but that's where it would probably go next, and if there were micro-mets there already, they wouldn't show on scans. I opted to have the pelvic lymph nodes included, which is done at a lower dose (46Gy) when there's no evidence of spread to them.
We also did 2 nights in hospital - going in the evening before to be checked by the junior doctors. Brachtherapy tubes inserted first thing next morning under anesthetic. Then off to imaging for MRI and CT scans for medical physics to work out the dosing schedule. When the dosing schedule is ready, another MRI just before the treatment in late afternoon to make sure none of the tubes have moved, and then straight into the brachy suite for the actual treatment. Then they whip out the tubes and continually flush your bladder overnight through the catheter, and go home in the morning after removing the catheter and demonstrating you can pee.
I'm not sure why you need two lots of local anesthetic. It's the insertion of the brachytherapy tubes which is done under anesthetic. The bachytherapy treatment isn't painful. There's a tiny wince when they pull the tubes out, but I think that only took about 3 seconds.
There was nothing painful.