How will a DWI or DUI affect opportunities to become an insurance claims adjuster?

It would depend on the company and their hiring practice. However, it will be a challenge as most claim adjuster position will require that you are able to drive to and from the client's home and work. You may want to look into claim center where the clients come to you. But then you will still need transportation to and from work.