The music legend famously retired from touring in 2023 to spend more time with his two children, who were last seen in public during Elton's Farewell Yellow Brick Road tour