The lead singer of one the most popular bands of the ’90s has tragically passed away at the age of 46