Read into it- it's not as scary as it sounds and it allows for more efficient aribtrage meaning tighter markets across services. The whole transaction is atomic meaning no risk for the lenders (lump sum must be paid back in a single transaction + small interest fee).

Flash loans are only executed if the entire transaction is valid monetarily. A transaction on Ethereum is like a database, if there are any issues it's rolled back.