My sympathy Pete, that stage did seem dire. I remember my entire life revolving around being able to find place to change pads.
However it did improve! We are all different, but in my case the psychological breakthrough was about 6 weeks after the operation. I was still using a lot of pads, but my wife encouraged me to try to manage the holiday we had booked before diagnosis (our daughter was at school and this was for summer half term). I found I managed quite a lot of the activities without disaster (those involving the sea had the benefit that no one could tell why my trunks were wet!) and got a huge boost.
Slowly the number of pads I needed each day came down, and the next big breakthrough was around 6 months when I found I never needed more than two pads a day. It then became easy, I had the confidence that with a spare pad in my back pocket I knew I was able to manage.
Hold on there, and good luck!