Adam, I'm not one of the professionals here, but I've had needle, thread and fabric in hand since infancy and I've had little choice to be anything other than self-taught. My Mom started me out, but by age 14 I wanted to do more than she felt comfortable with.
Many decades later, I came here to hone my skills with the excellent resources made available. But this site can be cumbersome to maneuver at this point - especially if you don't know enough to know what to look for.
First off - to answer your questions: Can dress-type woolen trousers be made to accommodate the physical needs of your profession? Yes. Absolutely.
Will you be able to create these with a commercially available pattern? I don't think there's a snowball's chance in hell of that happening. I think you will have to learn to draft your own pattern.
When I returned to garment sewing a few years ago, I thought I would just be able to alter commercial patterns to accommodate my middle aged body and posture. I am now learning to draft 'cause that doesn't really work, as I have too many issues to deal with. Not really time effective.
Anyway...from what you stated originally, you have limited sewing skills in general, but experience with other similar activities that leads me to believe you can do this, but it is a process. It may take you one to two years to produce your first pair of wearable trousers. There is so much to learn and understand.
Terri, on this site, ( she uses TTailor as a user on movsd.com - not sure what her user name is here, sorry!) is a theatrical tailor. She must create period costumes for performers to wear on stage. Actors/Dancers playing bankers, business men, professors - all must be able to pirouette, jump, squat, kick, etc. in her creations. She knows the tricks - it can be done, but this is nothing that you will learn overnight. I think she is super busy at the moment, but you can check out her blog at atailormadeit.blogspot.com. Tons of wonderful info there.
Also, go to movsd.com. the site was established when Cutterandtailor was experiencing "technical difficultuies", so there are many of the same members. Last spring JRuley posted muslin fittings of drafted trousers for both he and his wife ( under the "Drafting, Fitting, and Construction" forum). The photobucket debacle removed all of the photos - which is really a shame, but by quickly reading through the posts you can learn what you will need to know in order to get help from the professionals - when you are ready for it. There is a new thread begun by Will_F, that will also be of interest. Terri is active on that site when she has time.
Dig through Jeffery Diduch's blog "tuttofattoamano". Study anything applicable for your journey. It, like Terri's, is an AMAZING blog. Too much to even describe here.
The book "Trousers", by David Page Coffin. Buy it. Reasonably priced and gives very detailed studies of the making of trousers. David is also a member here - and will jump in to help - when you are ready.
This site and movsd.com has numerous trouser drafting resources when you reach that point. Roberto Cabrera's "Mens' Tailoring" is also a good starting point . For more overall sewing knowledge in general, a copy of Readers' Digest Guide to Sewing can answer many newbie questions. A copy from the late 70's or early 80's is best. the "updated versions" have cut out 150 pages. If there is a process I haven't done in a while (years?) I will pull out my copy and look it up just to refresh my memory and then proceed to add information I have learned here and elsewhere. The professionals will probably balk at that book choice, but it can answer many questions when you have no actual human to turn to IRL. Copies can be bought on Ebay for just a few dollars.
Fabric - there is so much to learn. But yes wool can be quite resilient. It not only has to do with the type of wool, but is very dependent on the twist of the individual wool yarns. There are also things like knee linings that can be designed to take the brunt of the knee action in trousers- reducing the amount of stress on the wool fabric. For your particular issues, some of the newer woolens are 98% Wool, 2% Spandex. This will probably be something you will want to explore eventually.
To start, I would suggest buying some inexpensive cotton twill. Don't waste money on wool at this point. Look at Burda patterns, they seem to have a few decent contemporary trouser patterns for men. Go ahead and install a full fly zipper (you'll need the practice). This will simply give you the opportunity to learn to manipulate the pattern pieces and seams, control the stitching for any top-stitching, study the quality of the straight stitch on your machine, learn about the different parts of the trouser, and most importantly help you study how your body differs from "the norm".
The most helpful tool you will have for fitting is the camera on your cell phone. Learn how to take selfies using the timer and figure out someplace in your home to quickly take 4 pics straight on from each side with good light. Learn how to study these for fit.
In college, I sold shoes and could not afford dry cleaning bills. We had a dress code. I constantly had to climb ladders ( in 3" to 4" heels!) and squat down on the floor. All of my dress trousers for many years were made from the same Simplicity Jeans patterns that I modified to not look like jeans. I used various weaves of cotton/polyester blends. The cotton was comfortable and the polyester allowed the wrinkles from squatting to release, helped keep the knees from bagging after squatting and sitting on those super low stools, and held the color through massive washings. The fabric was never shiny. My sewing machine had a stretch stitch and though I rarely sewed any knits, I always used that stretch stitch to sew the back seam on all of my trousers. I never once had a seat split on me - even with more than a little extra "junk in the trunk". There are all kinds of tricks that can be incorporated.
The really sad part is that those wonderful cotton/poly fabric blends from the 70's and 80's are almost impossible to find these days. I kept two pairs of those pants. When I pull them out every few years two things run through my mind: My waist was THAT small! and Wow! the fabric looks so fantastic for items worn and laundered a minimum of 200-300 times. Work, school, and clubbing - for years!
One other thing, if you lived in my town , I would try to locate a trained pattern maker to help develop a trouser pattern. Levi Strauss and a local upper end MTM Suiting company both employed trained pattern makers at one point. I've met two of them and they were both working for bridal shops doing alterations - last I heard. If you can find a patternmaker that would be a huge timesaver.