Target normal sheath acceleration: theory, comparison with experiments and future perspectives