a realistic timescale to go from zero experience (beyond taking the controls of a Chipmunk whilst in the RAF cadets 25 years ago) to being qualified
2 or 3 years modular - depends, some take a year to get PPL.
and in a position to realistically apply for the bottom rung on the airline pilot ladder?
10 years from now - When applicants may be sought.