Smart contracts are not executed automatically?

I always thought that all smart contracts are executed when conditions are met until I read about Chainlink Keepers, who are a network of node operators that help execute smart contracts. This is the part that got me confused – what are the examples of smart contracts not executing automatically such that they need manual execution?