If you choose not to pay for the upgrade, you won't be able to participate in Ranked matches anymore. Valve has introduced Unranked matches for Competitive, Wingman and Danger Zone game modes, though, which anybody on CS:GO can access.