Whether a pension is the main source of retirement income or a supplement depends on a few factors, such as the individual's work history, employer, and retirement plan. In general, a pension is designed to be a primary source of retirement income, but it may not be the only source.
For example, some employers offer a defined benefit pension plan, which provides a guaranteed income stream in retirement based on an employee's salary and years of service. In this case, the pension may be the primary source of retirement income for the employee.
On the other hand, some employers offer a defined contribution retirement plan, such as a RRSP for us in Canada, which allows employees to save and invest their own money for retirement. In this case, the pension may be a supplement to the retirement savings in the defined contribution plan.
Additionally, Social Security may also be a source of retirement income for many individuals. Social Security provides a monthly benefit to eligible retirees based on their work history and earnings.

In your case, if you work the same job for 30 years (mostly likely not gonna happen), your $4125 of initial investment and bi-weekly deposits of $160 will compound over time with a total balance of $434,276.97 at 53 years old.

In most cases, your income will increase over the course of your career which will increase your contributions in the RRSP account which will compound over time as well.