It can be linear although polynomial trends are permitted. To visually understand how it works, see the documentation section on Continuous Linear Trend.
If you apply the polyfit result the same way as detrend does, they will likely give the same result. The advantage to detrend is that it does all that with one call, specifying the dependent variable and the polynomial degree being the only requirements. (It also has additional options.)
(I generally use polyfit and polyval to detrend a baseline, using polyfit to fit the polynomial to the results of calling the islocalmin function with the dependent variable, and then using polyval with that polynomial on the entire independent variable vector to get the detrending vector.)