Hank Aaron - career OPS of .929 in 3298 games (12364 AB); 1477 XBH; 240 SB (77% success).
Babe Ruth - career OPS of 1.164 in 2503 games (8399 AB); 1356 XBH; 123 SB (51% success).
Pete Rose - career OPS of .784 in 3562 games (14053 AB); 1041 XBH; 198 SB (57% success).
In 2004, MLB average OPS was .763.
By today's standards, Rose is barely above average in terms of OPS. Based on the number of steals and his SB percentage, Rose cannot be said to have had great speed. Lastly, in fewer games and ABs, Aaron and Ruth both had many more XBH, such that Rose cannot be said to have had great power.
As for his records, they are mostly based on longevity. Which simply means he didn't suffer any major injuries and he played hurt - something he shared with Ripken, but does not equate to "greatness" in my book.
And, yes, I understand that most records are based on longevity, but if Aaron had the same number of ABs as Ruth, he would have still had over 500 HR. However, had Rose had the same ABs, he would have had fewer than 2600 hits - a feat that while good, is not nearly as impressive. Heck, Julio Franco will get his 2500th hit in the near future - and with a career OPS of .786 (higher than Rose's). If he played at this level for the next 10 years, and ended his career with 3500+ hits, I would not be talking about how "great" a player that Julio Franco was.
As for the doubles, the 746 is impressive to some extent, except that many of those were caused from him stretching a single into a double. Again, admirable for the hustle, but does not equate to him being a great player. And, honestly, with 4256 hits, he had to have a decent number of doubles, especially with so few other XBH. E.g. Jimmy Rollins has a higher 2B% (165 2B in 824 hits - 20%), higher 3B% (48 3B - 5.8%) and HR% (55 HR - 6.7%) than Rose (17.5 2B%, 3.2 3B%; 3.8 HR%) - and I surely don't consider Rollins to be a great player.
Also, the fact that he played 500 games at so many positions supports the argument that he was so bad defensively, he was moved around to try and limit the damage. And, on the defensive spectrum, 1st base is the lowest rung - meaning that when all else failed, they put him at the position at which he could do the least damage.
As SouthBronx said, Rose was a glorfied singles hitter who was fortunate to avoid serious injury and played for an exceptionally long time - and in many instances for good teams. He played with a lot of hustle, and turned many singles into doubles and doubles into triples due to this hustle. However, he did not hit for power (isolated slugging of just .106) and he did not possess good speed. He simply took average talent and parlayed that into great numbers. While that is impressive to some extent, it does not, IMHO, make him a great player. Great players, IMHO, have a career OPS above .800 (and, in reality, above .900).