Depends on what you mean by "Attitude Era." I think when most people say they wished the AE would come back, they simply mean they want wrestling to be as exciting again as it was then, not necessarily bring back Shock TV. A lot of the AE is garbage that really doesn't hold up too well today, when you look back on it. Overall, I wouldn't wish for it to come back in that way. And being TV-14 doesn't guarantee the show will get any better. So yeah, I'd love to see wrestling get as exciting again as it was back then, but not necessarily bring back the AE.
And the AE was long dead by 2004. People have different views on it, but I'd say it died in 2001, with either the start of the Invasion angle or Austin's heel turn/death of WCW.