1. Why Niklaus Wirth moved on from Pascal to Modula, and then to Oberon?
2. Is there any current worth mentioning professional software built with Modula or Oberon?
3. Is Modula or Oberon any better than modern Pascal?
I think many people are curious about at least the first 2 questions, which are very good ones. The 3rd question, of Pascal versus Modula and Oberon, has a lot to do with preference. Though a huge factor is Pascal having the corporate backing of Apple and then Borland/Embarcadero.
In a more recent interview done with Wirth (link below), there is more insight given into his thinking in regards to developing Modula and Oberon. It appears that in the case of the time frame of him doing Modula and Oberon, he was greatly curious about OS and hardware development. As a scientist, Wirth had a degree in electrical engineering and built his own TVs as a younger man. This background also corresponds with him developing the Lilith computer (link below).
In an alternate universe, Niklaus Wirth could have been the European replacement of Bill Gates or Steve Jobs. His Lilith computer, along with the operating system based on Modula-2 and Oberon came out in a competing time frame. Oberon, the OS, was out on computers when Windows 3.1 was being developed. In fact, a lot of research will have to be done to ascertain which was more advanced. It appears Oberon was in many respects, though eventually Microsoft's success, new versions, and money would mostly overwhelm all competitors.
His interests were beyond just programming languages. It could be argued that he didn't so much abandon Pascal, as he had his sights on higher goals or other pursuits in the computer industry (to include RISC Architecture and FPGA). We also have to remember, that he was an consultant on the development of Clascal (which became Object Pascal), so he still had his "fingers in the mix" there too. Lastly, an element of this is that Wirth retired in 1999 (was a professor since 1968). So his level of involvement in various pursuits appears to be not as vigorous as his younger days. Though even in retirement, he has done a lot of amazing things.
https://youtu.be/OEmMx55SF8U(Interview with Niklaus Wirth, subtitles are in English)
https://en.wikipedia.org/wiki/Lilith_(computer)(DISER Lilith, custom built computer with AMD processor, uses Modula-2 to build OS, started project in 1978)