Walsh will transition into the newly created role on July 1, charged with overseeing both the Wallaroos' 15-a-side game and the sevens programs.
One bronze medal in 2010 is the best Australia have placed in 10 World Cups, with the Wallaroos crushed 46-5 by Canada at last year's edition in England.
Even RA boss Phil Waugh concedes three years is barely enough time for the 2029 tournament hosts to bridge the gap on heavyweights England, New Zealand, Canada and the USA.
But Walsh was bullish when asked what a successful next campaign would look like for the Wallaroos.
"Winning," he said.
"I think it is possible, yeah. There's a lot of things that go into winning and a lot of it comes down to that day, but it's all the work done prior.
"This is a massive step forward to give us the best opportunity, so it's about creating an opportunity for the team to perform at their best and that's the objective, to give both the sevens programs and the Wallaroos the opportunity."
With World Rugby making a concerted effort to space out the major sevens and 15-a-side events, Waugh and Walsh are confident of having the best talent such as try-scoring phenomenon Maddison Levi playing both formats for Australia.
That would also help keep the game's superstars in rugby, as the NRL continues trying to raid the code.
"It'll be individually sort of planned and in their career management, but when you've got a home World Cup it's pretty attractive, and ultimately they're rugby players," Walsh said.
"So whether it will be sevens or 15s, they love playing. They love playing footy, so those opportunities will arise and it's up to us to be able to create those opportunities so they're in the best position to be able to perform at the right times.
"(The 2028) LA (Olympics) is obviously a very important performance indicator for Rugby Australia for the sevens, and then the '29 home World Cup."
Walsh famously guided the Australian women's sevens golden girls to Rio Games glory in 2016 just two years into the coaching role, before steering the current team to the world title last month.
But enduring the heartache of missing a medal in Paris last year is also driving him.
"Reviewing I find is one of the most satisfying things because you learn so much," Walsh said.
"Yeah, gut-wrenching. It was an event that we were there to win and we thought we were very much prepared for, but we didn't get the results.
"So getting those learnings from it and moving forward is a real positive."
RA president Kristy Giteau also hailed Walsh's appointment and said another major goal was making Australia's women's players full-time professionals.