No, the Saints didn't ask Moore for his opinion. Hiring Moore was just a PR stunt. They keep him locked up in secret closet in the team's building. They only let him out to make PR appearances, like interviews.
They'll let him walk the sidelines during the games with a play sheet and headset while pretending to be running things, but his headset will just be a prop and no one will actually be listening to anything he says. His hiring is all for show. Moore's just a powerless figurehead.