Can a member without admin privileges upgrade a workspace subscription?

No, only an admin of the workspace or a member with a billing role can upgrade the workspace subscription to a paid plan.