It depends on the company to give a managerial post. If it is a 10-person company, they may directly offer a manager position. Even if you don't know how to spell "manager," MNCs and Fortune 500 companies might give a Senior Executive designation even after 5 years because they have a grading system and many policies. Even if they are letting you go, they will provide you with one month's salary and bid you farewell. On the other hand, companies that demote you from a manager position will simply inform you by saying, "Mr. XYZ, don't come to the office from tomorrow. You have done nothing as an HR, so we don't need you." (Today's corporate training expects HRs to develop sales skills as well.)
Future of HR
Speaking of the future of HR, don't chase success; let success chase you. ("Oops! So soon you forgot the '3 Idiots' dialogue, shame on you, man!") Everything carries value and deserves respect. All you need to do is become an expert in the area that you and your heart enjoy working in for 10 hours a day.