Yes, or no. Yup, that's the answer. If you're enjoying it then why do you require the validation of your peers? If you're questioning your own experiences, or need validation from other people, then no, no you probably should not keep playing Destiny.
Destiny's worst fault is that it's not a great game, it's disappointing but that's not always a bad thing. People play a lot of games that are not perfect or have flaws but are just good, if not especially amazing. People just happen to enjoy the game play, the style, the setting or whatever, and that's really just fine. If you're enjoying the game play, style or just happen like the world and see enough hooks to keep you going while you don't regret your time played, then great, you've found a game that works for you! Maybe try Diablo 3, World of Warcraft, Anime inspired Visual Novels, Zombie Survival Games, Crack Cocaine, Hunkadunk, Mario Party or any of the other games that have a repetitive hook and a large and active player base? Everyone has their niche and maybe Destiny is yours?
There will always be people playing, it is not a wildly successful MMO with millions of logins per day, but so what? There's an active player base and if you know people that are playing then all the better, if not the people playing should welcome new allies. People still play the Lord of the Rings MMO and that's now a free to play cash shop driven grind fest and came out in 2007 trying to compete with World of Warcraft. (full disclosure, I love that game).
If all else fails you've randomly inspired some dude on the internet to defend Destiny as a game you should play, even though this random dude hasn't really played it... he also doesn't care about Destiny. But why should that stop you? Go forth and enjoy... maybe?