Server-side request forgery happens when an application takes a URL or address from the user and makes a request to it from the server. Because that request originates from inside the network, it can reach places the user never could: internal-only services, admin panels bound to localhost, and, in the cloud, the instance metadata service that hands out credentials.
The attacker's goal is to control the destination of that server-side request. A feature meant to fetch a product image or check a webhook becomes a way to make the trusted server talk to internal systems on the attacker's behalf, turning a harmless-looking input into a pivot into the internal network.