Since your wife and mother-in-law are apparently Monet fans, I'd venture that their main destination in Rouen would be the cathedral, which Monet painted many times in different lighting conditions. It's right in the historic center and is only about a kilometer from the train station.