Drunk to excess or extreme with /associated wild or crazy behaviour. Rock stars that set the precedent include Mick Jagger and any member of the Rolling Stones, amongst many other well known rock stars.
"Mum was rock star drunk last night and fell through the motel hotel window"