The invention discloses a regular carrier catalyst with a desulfurization effect as well as preparation and application thereof. The catalyst comprises a regular carrier and an active coating attachedto the outer surface of the regular carrier, the active coating comprises a IIA and IIB group metal oxide-containing matrix, a molecular sieve and a modified metal film, the modified metal film comprises a modified metal, and the modified metal comprises one or more of Cr, Mo and W. The preparation method comprises the following steps: forming a mixture from metal powder, a hydroxyl-containing solvent and a surfactant, then treating the mixture under ultrasonic waves to obtain a mixed solution after the ultrasonic treatment; separating the mixed solution after the ultrasonic treatment to obtain suspension; contacting the suspension with matrix particles and / or molecular sieve particles or particles containing a matrix and a molecular sieve, freeze-drying, and then coating on a regular carrier. The catalyst can be used for hydro-desulfurization of hydrocarbon fuel, has the characteristics of high activity and good stability, is used for gasoline desulfurization, and can increase the octane number of gasoline.