Aave's documentation [1] is pretty good if you're interested in doing a deeper dive. But yeah, it's a collateralized loan where the borrower stakes some ETH.
So the idea is that I can take $100 worth of ETH and put that up as collateral for a $75 loan. And if the value of my collateral drops due to the ETH<>USD exchange rate I have to stake more collateral. If I don't (or if the exchange rate moves below a certain point) then my collateral is automatically liquidated at a discount. So in this case, if the value of my collateral falls to $80 the contract will put it up for sale at $75 -- this creates an arbitrage opportunity, so the liquidation will likely happen very quickly.
There are other lending protocols where you can stake other assets (NFTs, other tokens, etc.), but this is my understanding of how Aave works.
[1] https://docs.aave.com/faq/