Hate to burst everyones bubbles, but whether you like him or not, HHH has actually been one of WWEs biggest draws in ages, and during the DX revival, his popularity was at an all time high.
The drop in ratings can be attributed to both him and HBK being out injured, and guys like Cena and Lashley not being anywhere near as popular as WWE would like.
As for his acting abilities, as long as he sticks to non demanding roles (like Thor as lets face it, thats not gonna need a Deniro level actor), he can be ok.
Despite Blade Trinity being shite, HHH was one of the more fun aspects of the film as it didnt stretch him.