There was a character called Pilar in one of Agatha Christie’s books (I think it’s a Poirot one, not sure without reverting to Google). Which makes me think it might be a generational name. But I’m certainly no expert on Spanish names, and I’m basing my assumption on very little evidence.
I know many Spanish speaking women under 40 called Pilar.