Higher numbers of attunement slots enable more magics to be cast, with attuning multiple copies of the same magic allowing for more total uses. Each attuned magic has a limited number of uses that can be restored by resting at a bonfire.
Attunement is the stat determining one's number of attunement slots available for Pyromancies, Sorceries, and Miracles.