A debt consolidation loan is an ordinary personal loan used for a specific purpose: you borrow enough to pay out several existing debts, then repay the single new loan instead. There is no special product category and usually no special rate. What makes it a consolidation loan is what you do with the money.
The debts people combine are typically credit cards, buy now pay later balances, store cards and other personal loans. What these have in common is high rates and, in the case of cards and buy now pay later, no fixed end date. Those two properties are what make them expensive over time, and consolidation addresses both.
Two things change when you consolidate, and they are worth separating because only one of them is about money. The first is the interest rate: a personal loan at, say, 9% replacing card debt at 21% obviously costs less to carry. The second is the structure: a personal loan has a fixed term, fixed repayments and a date on which it ends, whereas a credit card limit sits there indefinitely and can be redrawn the moment it is paid down. For many people the structural change matters more than the rate.