Mrs c, you seem to be jumping to the conclusion that your sex life is gone forever. It isn't!
I had non-nerve sparing surgery, and as a result of that have no natural erections at all -- but I live in hope With the aid of injections, my wife of 38 years and I find that sex is every bit as good as before -- in some aspects better, because I last a lot longer. Of course, if we could wind the clock back we would, but what we have now is a very good second best.
Even if the worst happened and your hubby can no longer have erections, there are many alternatives for a happy sex-life. There are new fun things to learn -- for example we discovered the "g-spot" -- something neither of us knew about before.
If all else fails, there is a penile implant -- which from all accounts is very effective.
The chances good that your hubby will still be able to have erections one way or another, but there will be a learning curve with the new techniques. So I suggest as soon as hubby is able, get involved in gentle sexual activity -- you'll both feel a lot better. We were fooling around before the catheter came out, and first full intercourse was exactly one month after surgery.
So it's not the end of everything, just a detour -- enjoy the journey