While the enchanted player can still activate mana abilities and loyalty abilities, creatures that player controls won't normally have any of those abilities to be activated.

An activated mana ability is one that produces mana as it resolves, not one that costs mana to activate. A loyalty ability is an ability of a planeswalker whose cost specifies how many loyalty counters to give or remove.

If Overwhelming Splendor leaves the battlefield at the same time as a creature enchanted player controls, any "when [this creature] [dies or leaves the battlefield]" abilities of that creature won't trigger.

If a noncreature permanent becomes a creature, it will lose all abilities it has. However, if the effect that makes that permanent a creature grants it an ability, it will continue to have that ability. For example, the enchanted player's Riddleform will have flying once it becomes a creature.

Activated abilities contain a colon. They're generally written "[Cost]: [Effect]." Some keyword abilities (such as equip and eternalize) are activated abilities and will have colons in their reminder text. Triggered abilities (starting with "when," "whenever," or "at") of noncreature permanents are unaffected by the last ability of Overwhelming Splendor.

If an effect grants a creature an ability after Overwhelming Splendor has become attached to its controller, that creature won't lose that ability.

Effects that modify a creature's power and/or toughness, such as the effect of Titanic Growth, will apply to the creatures no matter when they started to take effect. The same is true for any counters that change their power and/or toughness.

Overwhelming Splendor overwrites all previous effects that set a creature's base power and toughness to specific values. Any power- or toughness-setting effects that start to apply to a creature after Overwhelming Splendor becomes attached to its controller will overwrite this effect. For example, the enchanted player's Riddleform will become a 3/3 creature if player casts a noncreature spell.

If a creature enters the battlefield under enchanted player's control, any "when [this creature] enters the battlefield" abilities of that creature won't trigger. Any "as [this creature] enters the battlefield" or "[this creature] enters the battlefield with" abilities won't be applied.